|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 2nd, 2009, 02:52 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
database design
http://robertkelly-carrollia.com/dbrelationships.html
This size table should be coming off the inventory table I think. How do I do it? -- rjk 
|
|
#2
February 2nd, 2009, 03:04 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
database design
Delete the line from Sized to Sales and drag ProductCode from Inventory to ProductCode on Sizes table
-- Danny J Lesandrini www.amazecreations.com "Walmondo Kelly" wrote in message ... http://robertkelly-carrollia.com/dbrelationships.html This size table should be coming off the inventory table I think. How do I do it? -- rjk
|
|
#3
February 2nd, 2009, 03:17 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
database design
It isn't clear how your tables all related.
I would consider creating a primary key field in the sizes table named [ProdSize]. This would create a unique combination of product and size. The Sizes table would be linked to the Inventory table. The Sales table would then need to include the ProdSize field value as a foreign key to the Sizes table. You could then remove the ProductCode and Size fields from the Sales table. Width is not a good name for a field since it is a property of reports, forms, controls, etc. -- Duane Hookom Microsoft Access MVP "Walmondo Kelly" wrote: http://robertkelly-carrollia.com/dbrelationships.html This size table should be coming off the inventory table I think. How do I do it? -- rjk
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
