Thank you for all the advice everyone, I'm going to try and explain what we have and hopefully someone can help me find out where to start. Twincam your method is how I thought of doing it having separate tables but wanted to see if it was possible to have one table to hold all...
The company who makes the software has replied with how they store and call the relationships:
New Table for Variation Group ~ [VariationItem]
New Table for Variation Child SKU's ~ [StockItem_Variations]
They have included some sample SQL code which I have attached so I am guessing it is...
We are trying to make a new database from the ground up as in the past we have been using excel sheets to accomplish what we wanted but we have outgrown these and data is spread over too many sheets and causing too many calculations when ever a value is changed on even one product on the sheet...
@plog I've removed the direct link between VariationGroups and Products, the thing is each VariationGroup must have its own parent Product that exists in the Products table and has its own SKU, I have attached the access database with the sample data.
How do I run a query that returns the...
Ok, lets start again with just the basic relationships.
Please see the new attachment.
A VariationGroup can have many Products and a Product can belong to many VariationGroup so you end up with a many-to-many table called VariationGroupsToProducts.
Now what if we want each variation group to...
Hi,
Thank you for the input everyone.
Lets simplify it as the database is actually for inventory, but what i am trying to do is have an inherit structure to it so...
There is a parent product that can have many child products. Attributes/Product Specifics can be attached to the parent product...
Also forgot to mention sample data includes all the different types of products that can exist (3 groups with 7 products in total, 1 single product)
Everything is fine in the Merged Query until you get to 00004B001XAM456. As you can see it has two material values as the value "Fabric" has been...
Hi,
I am in the process of designing a database but require some help with how the tables should be setup and if queries can return the required information.
This is the basic information of what is required:
The company has many products and each product can either be a single product or...