|
| 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
April 7th, 2009, 02:42 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Inventory table into smaller tables or just one
I'm building a database for a construction database. The inventory items
will have a category (10+ types) and also a sub category (10+ types). Would this be better to keep as one table, or break into smaller tables for each category. If the user creates a new category I would then create a new table. It seems to be easier to keep in one table. Am I correct in this assumption? thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200904/1 
|
|
#2
April 7th, 2009, 03:10 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Inventory table into smaller tables or just one
On Tue, 07 Apr 2009 01:42:47 GMT, "drtaclem via AccessMonster.com"
u50213@uwe wrote: It seems to be easier to keep in one table. Am I correct in this assumption? Absolutely. Your Categories table would have fields for Category and Subcategory; you could use a "SELECT DISTINCT" query to create a combo box (for example) displaying just one record for each category, and another query referencing that combo box to create a dependent combo box showing only the subcategories for the selected category. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
