meiteniite89
New member
- Local time
- Today, 12:08
- Joined
- Aug 13, 2020
- Messages
- 23
Hello,
I have created a form called Update info, see attached file.
Majority of this information is stored in table ALLGaugeDB, but Area, Location, Location Name and Location Code are stored in second table AREA.
Data is linked using Location Code (that is on both tables).
Area/Location/Location Name/ Location Code are used as combo boxes based on previous choice list in next one changes.
My question is how after updating all or some information do I get to save info only in ALLGaugDB and not change anything in table AREA? Right now every time I change Area/Location/Location Name/Location Code it creates new entry in AREA table with this info.
If I lock table AREA or combo boxes, I can't save any of this info.
Please note: table AREA is fixed and no new entries are added to it.
Thank you
I have created a form called Update info, see attached file.
Majority of this information is stored in table ALLGaugeDB, but Area, Location, Location Name and Location Code are stored in second table AREA.
Data is linked using Location Code (that is on both tables).
Area/Location/Location Name/ Location Code are used as combo boxes based on previous choice list in next one changes.
My question is how after updating all or some information do I get to save info only in ALLGaugDB and not change anything in table AREA? Right now every time I change Area/Location/Location Name/Location Code it creates new entry in AREA table with this info.
If I lock table AREA or combo boxes, I can't save any of this info.
Please note: table AREA is fixed and no new entries are added to it.
Thank you