I keep getting this messgae that says "tyhe current field must match the join key in the table that serves as the one side of the one-to-many relationship"
Im working on a subform that im using a query on, Can someone advise as to what i should do, THANKS IN ADVANCE
>> i found a waya around that, i just took out one of the tables that was in the query and changed the control source for one of the combo boxes, the problem is, im using cascading combo boxes now and once a change the value in the unbound combo box,the value in all the other combo boxes change although the records in the bounded one doesnt. How do i get the unbound combo box to display the corresponding value
e.g.
Unbound combo box shows, Keyboard. and bounded combo box lists the type of keyboard connections ps2 usb etc.
how do i get the unbound combo box to stop changing when i select another value in the next row of data and also display the correct information according to the bound combo box.
I read the post "Asking questionst the smart way"
This is just a little frustrating. Please Advise.
Im working on a subform that im using a query on, Can someone advise as to what i should do, THANKS IN ADVANCE
>> i found a waya around that, i just took out one of the tables that was in the query and changed the control source for one of the combo boxes, the problem is, im using cascading combo boxes now and once a change the value in the unbound combo box,the value in all the other combo boxes change although the records in the bounded one doesnt. How do i get the unbound combo box to display the corresponding value
e.g.
Unbound combo box shows, Keyboard. and bounded combo box lists the type of keyboard connections ps2 usb etc.
how do i get the unbound combo box to stop changing when i select another value in the next row of data and also display the correct information according to the bound combo box.
I read the post "Asking questionst the smart way"
This is just a little frustrating. Please Advise.
Last edited:
