Dlook up values not in table

[wrweaver]

Table 1 has
FieldID1 and FieldID1Name

Table 2 has
FieldID2 FieldID1 Field ID2Name

Table 3 has
FieldID3 FieldID2 FieldID3Name

Table 4 has
FiledID4 FieldID3 FieldID4Name

The form for table 4 contains a button that opens another form where the values for FieldID1 FieldID2 FieldID3 and FieldID4 are stored in combo boxes that display them by FieldIDNames. I don't understand how to get the dlookup function to get the value of FieldID1.

Here's the rest of the code I have for the button

DoCmd.OpenForm "FormNameF", , , , acFormAdd
Forms!FormNameF!FieldID1Combo = DLOOKUP(?????????)
Forms!FormNameF!FieldID2Combo = DLookup("FieldID2", "Table3", "FieldID3" & FieldID3)
Forms!FormNameF!FieldID3Combo = FieldID3
Forms!WorkOrderF!FieldID4Combo = FieldID4

All help is appreciated!

 

[pr2-eugin]

Hello wrweaver, I have read your description again and again, but could not understand what you are trying to do.. Is it possible for you to upload a DUMMY version of your DB, for us to look at, so we could understand what might be wrong??

I also think there is some Design issues that needs to be addressed here, to give a proper solution.

 

[wrweaver]

Does this help?