From: tasha on
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,

From: tasha on
pls disregard this post. question correctly stated in abone post.

"tasha" wrote:

> I have 3 tables that will be related on two different fields:
> tblPackaging & tblPackaging_Materials on chrMaster_Case
> tblPackaging_Materials.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,