newbie question

[pacaskurban]

Hello,

I am planning to build a database, I need to put in products with multiple variations and depending on the variations the price changes.



Like this:

A4 notes (main product)
Glossy (variation 1)
Plain (variation 2) (also has different price)
100 pcs (variation 3)
1000 pcs (variation 4)

Ofc 1000 pcs of variation 2 are more expensive then 1000 pcs of variation 1. How can I establish this? Do I need to make a new table for every variation?

[ranman256]

No. They all go into the 1 table using an auto number key field.
fields:
keyID
product
variation
pcs
descr

[ssanfu]

Since you state that you are a "newbie" (welcome to the forum), I would strongly advise working through the tutorials at Roger's Access Library.
http://www.rogersaccesslibrary.com/forum/forum46.html

[JLCan]

Hi Pakas!

You need 2 tables: one for Products and one for Variations.
In table Products, you store prod. name and other info.
In table Variations, you store description, qty and price.
Finally, establish a 1-to-many relationship between Products and Variations.

P.S. - You most probably have repetitive descriptions and qtys. So create tables to store then and repeat the 1-to-many relationship for each of them.
Sounds complicated? Just proceed with ssanfu suggestion.

Good luck, JLCan.

[pacaskurban]

Thank you so much for responding and helpful tips, I am going to try it out I will keep you guys updated!