2015imsjfw
New member
- Local time
- Today, 02:54
- Joined
- Oct 22, 2017
- Messages
- 1
I'm new to Access and have some questions.
Goal: Create a Scheduling DB for my Machine Shop
Tasks: Enter Router Data into tables - Job#s 1150-10450 (and counting)
I need some advice on how much of the Router Data to put in 1 table. Each Router has standard info such as job#,dates, part#, part revision, part description, quality info, engineer info, qty, PO #, Contract#,...
The second part of each Router has info for each Operation used to manufacture the part. OP 010, OP 020, OP 030... sometimes up to 30 ops per part.
Should I make a table with just the standard info then a separate table for the ops or each op?
Goal: Create a Scheduling DB for my Machine Shop
Tasks: Enter Router Data into tables - Job#s 1150-10450 (and counting)
I need some advice on how much of the Router Data to put in 1 table. Each Router has standard info such as job#,dates, part#, part revision, part description, quality info, engineer info, qty, PO #, Contract#,...
The second part of each Router has info for each Operation used to manufacture the part. OP 010, OP 020, OP 030... sometimes up to 30 ops per part.
Should I make a table with just the standard info then a separate table for the ops or each op?