
I'm stuck on the following issues
1) I have 4 tables
2) Table 1 has a primary key with values of A, B, C
3) Table 2 has a primary key with values 1,2,3,4 with a key column referencing the primary key in Table 1
4) Table 3 has a primary key of values 9,10,11,12 with a key column referencing the primary key in Table 2. So in turn, it "should be referenced to Table 1 A,B,C since Table 2 has the key column reference for Table 1.
5) Table 4 has a primary key with values of X, Y, Z with a key column referencing the primary key in Table 1
This is where I am stuck. If I create a dropdown on a form for Table 4 with values from Table 5, how can I restrict to only show those records that are have the key reference from Table 1.
This may give a better idea:
Table 1
Key Value: A Description: Company A
Table 2
Key Value: 1 Description: Header 1
Company: A
Table 3
Key Value: 10 Description: Detail 1
Header: 1
<Here I need the dropdown, but ONLY those people that have the company of A, which is in my header reference>
Table 4
Key Value: X Description: Sally
Company: A
My question is, should I create the Company in the Detail as well as header and automatically create the company when the detail is created from the header or is there another way?
hey @bdherhx
This will help you
---------------------------------------------------------------------------
If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !
Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow