Combo Box/Relationship Help

T

tasha

I have 3 tables that will be related on two different fields:
tblPackaging_Materials & tblMasterCaseDetails on chrMaster_Case
tblMasterCaseDetails.lngzPallet_Diagram_Index &
tblPallet_Diagram.idsPalletImageID

I want lngzPallet_Diagram_Index to auto-populate based on the chosen Master
Case. I also need to be able to use the same Master Case for several
different items. Can someone help me out with this?

tia,
 
Top