We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
ProductVariantNameTitle: DLookUp("ConditionCode","ProductVariantDescriptionTable") & " " & DLookUp("ProductNameTitle","ParentProductTable")
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.