Hi I have an issue when trying to create a table with just the invoice # for receivings.
I’ve created the correct relationships, a master sku table with all the sku’s. then connected the receivings table, sales table and on hand tables back as a one to many.
When i create a pivot table for sales it works fine. I pull the model info and details from the sku master table and the connected sales table the date, transaction and location.
But with the same table structure i cant produce the same with the receivings table. It lists all the receivings in the system, not just the receivings for just that filtered model.
I’ve tried creating a new table with just the model and a simple receivings table with the model. same error.
Crazy, i’ve tried all i can think of.
The Sku master table has the following: BRAND, MODEL, SKU, PRICE… The sku is the common link back to all other tables.
I’ve attached an image of the connections
Attachments:
You must be
logged in to view attached files.