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")
|Pivot Table for a join with partition by and over clause||7||27|
|Access Report that will show table changes||7||45|
|Unable to save view in SSMS||21||57|
|VBA pass value between two fields different tables||10||37|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!