Fashion Sales Business

[Junia]

(Access 2000)
I need a FashionProducts table to have:
- availableSizing (range goes from S,M,L,XL to 4,6,8,10,12..but some sizes
for every garment.)
- availableColors (black, white etc)
- availableTextile

So I have created a series of tables: SIZE, COLOR, TEXTILE and am trying to
get this working. I am not a programmer, so I have to do it by Access
settings.

My first question is how to set the data records for each of those 3 tables.

What kind of settings do I need to LOOKUP
DISPLAY CONTROL
ROW SOURCE TYPE

I will appreciate your help.

 

[tina]

sounds like you're asking how to create Lookup fields in a table; my strong
recommendation is that you don't do it at all. see
http://home.att.net/~california.db/tips.html#aTip8 for reasons why.

based on the information in your post, suggest the following tables, as

tblSizes
SizeID (primary key)
Size (S, M, L, etc)

tblColors
ColorID (pk)
Color

tblTextiles
TextileID (pk)
Textile

tblProducts
ProductID (pk)
ProductName

tblProductInventory
InventoryID (pk)
ProductID (foreign key from tblProducts)
SizeID (fk from tblSizes)
ColorID (fk, tblColors)
TextileID (fk, tblTextiles)
Quantity
(not sure what you're tracking with this database, so the Quantity field
might not be appropriate, and the table name might be more descriptive as
tblProductDetails.)

use a form for your data entry, and combo boxes *in the form* to allow the
user to choose a product, size, color, and textile for each record in
tblProductInventory.

hth

 

[Junia]

Thank you so very much Tina. Makes sense to have the combo box as choice of
the * form * and not for table data records. I got the message. Also, I will
take a look at the Lookup tips link to get to know the reasons.
Regards from South Florida

 

[tina]

you're welcome

Thank you so very much Tina. Makes sense to have the combo box as choice of
the * form * and not for table data records. I got the message. Also, I will
take a look at the Lookup tips link to get to know the reasons.
Regards from South Florida