Parts Table
Hello,
Ok new to access and figured most things out but have a table question.
I have a table for
Part Number (Key)
Description
UOM
MFG Code
Now in my testing I just figured out some parts have an alternate Part Number.
Do I make a new table lising the alternate part number and link to primary part number or enter all the alternate part numbers in the primary table and loop back to it for listing alternate part numbers???
Note some time a part can have multiple Alternate part numbers.
MB
Last edited by MBCMDR; 10-28-2009 at 11:42 PM. Reason: Added Note
Given that, I'd go for a new table, otherwise you'll end up with a lot of unused fields in the original table.Note some time a part can have multiple Alternate part numbers.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Create a table with it's own ID, primary part no and alternate part no as the columns, and you can then look these up and display them from there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks