Subform based on 3 combination combo boxes

[mandalocascio]

Hello,

I have 3 tables in order of hierarchy Job number, location, site - each of these tables has an autonumber unique ID ie job number (text field), job number ID (autonumber primary key).

There is a data entry table which is basically for entering data collect in the field were every data sheet in paper has a unique number (so you can go back to the original)

I have set up 3 combo boxes linked to a subform ie data sheet ID, select job number, select location (based on job number).

i want the sub form to duplicate the data sheet ID, the job number and the location selected in the comboboxes - OK done by setting relationship Master and Child.

the problem is i want to only be able to select sites in the sub form that occur under a given location (specified by selection in cmbo box). this sounds simple i think but i am struggling! I have been able to use a text box control to display records based on combo boxes found on this forum, but as i am duplicating the datasheetID, JobNumberID, and LocationID these are in the Child and Master fields, is this the right approach?

i have a simplified version of the database but cant upload as i am new to forum, i have a dropbox account if that helps.

Thanks, Amanda

 

[mandalocascio]

Sorted there are 100+ post on this sorry i wasn't sure what terms to use - after lots of reading. i used link master and child fields then cascading combos limited in criteria field. and made the site field in the subform a combo box to also limited by combo in main form in the criteria field. happy woman!!! I'm happy to help any beginers but as i am one myself i dont think i can fix any problems !!! wooohoooo