Tables

[bobbak2011]

Hi,

I am trying to set up database to sell jeans in store and online. I have created table that includes wash color, style, style number, user id, payment, billing, shipping tables and etc. It appears to me that I am making this way to complicated because i am new to access. I wonder if there is anyone out there that could give a hand and guide and help me out and tell me if i have overdone it or not?
Thanks

[pkstormy]

Why do you think it's to complicated? You need a field for each kind of data you're collecting (and table(s) to organize the fields appropriately). The over-complication comes in to play when you do something for example, such as putting only 1 field in each table. Create your tables with the fields and show us your relationships between the tables and we can then tell you if it's overly complicated. If you only need one table for all the fields, that's ok to. Just give us more info on your setup.