Hi,
I am new to Access but have some experience with Excel and I understand basic concept of databases.
I will have to setup a small database and need some help with its structure, I am not sure if I should have two or more tables.
I want to create different product templates for different customers. Properties of a product within a template will vary, e.g quantity, size etc.
User actions will be,
· Assign Product templates to different customers
· Change properties for a product within a Product template.
· Add/Remove products in a product template.
· Create new product templates. User should be able to copy an old template and start from there.
In order to
· Create internal reports to know what each product template consists of what respective customer can expect
· Create nice looking summary reports of customers and their respective template, for new and old customers
My question now is how many tables should I use for this? I will illustrate my fields as example.
I will obviously need one table with customer.
CustomerT
FirstName LastName Adress ProductTemplate John Snow Winterfell 1
Will it be enough if I then just create table with templates?
product template quantity size category apple 1 5 2 fruit apple 2 2 1 fruit apple 3 1 - fruit
Size and quantity are properties that will vary between different templates.
I have some difficulties to see if it would be better with additional tables.
I really appreciate some guidance in this and happy to clarify if something is unclear.