G.Gard
02-19-2015, 03:07 PM
Hello again, I have ran into another issue.
I am trying to connect two values that the user inputs from a combo box via the 'allow value list edits' button.
I'm trying to update two fields, one called Customers and the other called Rigs. What I want to have happen is:
'user inputs new data to the Customers combo box, E.g. "RKI". then i need the corresponding new rig to connect to the new customer. so e.g. Rig1 = RKI.
I have tried using a update query but keep on having the same issue, that being the relationship between the fields cannot be updated. I tried connecting the customer AutoID number to the Rigs customerID number but was having this issue.
Short version: i need a new rig to correlate to the customer. the customer doesn't have to be new, but the rig will be new. the preexisting rigs do not connect either.
Any help is greatly appreciated!
I am trying to connect two values that the user inputs from a combo box via the 'allow value list edits' button.
I'm trying to update two fields, one called Customers and the other called Rigs. What I want to have happen is:
'user inputs new data to the Customers combo box, E.g. "RKI". then i need the corresponding new rig to connect to the new customer. so e.g. Rig1 = RKI.
I have tried using a update query but keep on having the same issue, that being the relationship between the fields cannot be updated. I tried connecting the customer AutoID number to the Rigs customerID number but was having this issue.
Short version: i need a new rig to correlate to the customer. the customer doesn't have to be new, but the rig will be new. the preexisting rigs do not connect either.
Any help is greatly appreciated!