Well I'm stuck again, any help would be GREATLY appreciated!
Lets start with the 4 tables
PurchaseOrder - Holds the Vendor Info, terms, dates and unique key
PurchaseOrderItems - Holds the items being purchased, includes Quantity, Category, description, part-no, unit value, total cost)
ProductList - Holds the Product Unique ID, Category, and Description.
ProductListPartNo - Holds the Product Unique ID, Vendor Name, Vendor Part No, Vendor Price
*I've had to create a portal to hold part numbers, because my client's have concerns that they have multiple vendors and want to track the product keys for each vendor*
So that's easy breezy,
The problem now lies with the almighty value list
PO_Category - Easy simply uses all the values in Product Category
PO_Description - Easy, relates to Category, and displays the related Descriptions.
PO_PartNo - Hard, here is the problem, this value list must display all the related PartNo's to the descriptions.
Category > Description > Part No
Pet Cat 1122 PJ Pet Store
It seems that once i try to get 3 value lists deep, the relationship seems to break.
I'm kinda lost on this one I'm going to keep working on it, but i could use the help.
Oh one more thing, once i get this the next step is to have the PurchaseOrderItems Table Lookup the UnitCost of the item from the PartNo, Description, and Category.
Oh the joys!
Thanks for reading!