Table for Products
- Thread starter tmyers
- Start date
raziel3
Registered User.
- Local time
- Yesterday, 21:43
- Joined
- Oct 5, 2017
- Messages
- 311
I'm kinda lost on the thread but for the OP which is normalizing the tables, why do you have a Products table and a ProductDetail table?
I would have a Products Table set up like in post #18 capturing all the Product Identifier(s), A Purchase Table to capture the Product Cost and a Price Table to capture all the different levels of pricing based on job criteria.
I would have a Products Table set up like in post #18 capturing all the Product Identifier(s), A Purchase Table to capture the Product Cost and a Price Table to capture all the different levels of pricing based on job criteria.
Last edited:
- Local time
- Yesterday, 20:43
- Joined
- Feb 19, 2002
- Messages
- 45,438
Then why are you modifying the part numbers? You are obfuscating the relationships. I think you really need to stand back from this and understand how you get from a to b to c and back to b again without changing ANYTHING.
I fully agree at this point. I am stopping and thinking about it more.
