PartID and SubpartID and the relationship when populating order..

[Stephanie53]

I have the following Tables/Queries and the Fields...

tblROT_5K_Hoses - Fields in this is PrimaryID (which is the part# of hose), Type, Description, Qty etc etc


tblROT_5K_Subparts - Fields in this is SubpartID, PrimaryID, Description, Qty etc etc
qryROT_5K_Hoses - same field lookups for above
qryROT_5K_Subparts - same fields lookups as above

Created a Form/Subform -
Main form is ROT_5K-Hoses
Subform is ROT_5K_Subparts

Now per the Main form I want when I select one of the PrimaryID and then go to the subform and select the subpart that it only gives the primary that matches to the subparts in the drop down combo box....

I have them in a relationship from the tables to a PrimaryID/SubpartID

But yet I am unable to get this linked together to show what I want...

How can I get this to work that way??

TIA

Stephanie

[June7]

Sounds like dependent (cascading) comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html

[Stephanie53]

ok in previous posts which there is alot from me requesting alot of help..this is one of the many issues I am having...Cascading box is not acceptable for this type of request

How can we (June and I) communicate better? I tried to PM and you tell me to go back to original post..and when I come back to these posts they are all seperate and yet the same issues tied into one another.

Please advise

And TIA very much :-))