Ok I have (May Not Be The Right or Best Way) 2 different tables set up currently. One Is called
and the other is called
. The Table
keeps track of all the products and is the basic parent form of the product. There is a field called "
which is the basic name and title of the product. There is 4 different variations of each product in the
The Variations are called NSOP,NSSP,USOP,USSP . Each one is a record in the field
in the table
. I just am thinking this is the bestway to set this up currently. What I am trying to do is perform a query to make one of the
record names go in front of the
Example would be ProductNameTitle = Yellow Bus 20 seat ....... ConditionCode = NSOP = NSOP Yellow Bus 20 Seat
I then will have to do this the same way for the other 3 remaining NSSP,USOP,USSP
I am having a hard time getting it to work and only thing so far I have had happen is the Dlookup return just the first record of each table with code
ProductVariantNameTitle: DLookUp("ConditionCode","ProductVariantDescriptionTable") & " " & DLookUp("ProductNameTitle","ParentProductTable")
I don't know if Nesting Dlookups would work exactly and how to code multiple nesting Dlookups.
Please and thank you to all!