S
studlength
Hello all.
I've been learning from this group for a while but this is my first
post. I'm also fairly new to designing databases, so please take it
easy on me. I'm trying to create a database for my company to track
customers and take orders on. I've studied the Northwind db and think
I grasp the concepts used. However, our company is unique in that we
only sell 3 products (and always will). Given this fact, would it be
smart to simplify the whole process by eliminating the Order Details
table and subform? I would like to just put a field for each product
on the Orders form to enter the quantities ordered. In other words,
the Orders table and form would have fields for Quantity Product 1,
Quantity Product 2, and Quantity Product 3. Is this a good idea or am
I missing something?
Thanks for any and all help.
I've been learning from this group for a while but this is my first
post. I'm also fairly new to designing databases, so please take it
easy on me. I'm trying to create a database for my company to track
customers and take orders on. I've studied the Northwind db and think
I grasp the concepts used. However, our company is unique in that we
only sell 3 products (and always will). Given this fact, would it be
smart to simplify the whole process by eliminating the Order Details
table and subform? I would like to just put a field for each product
on the Orders form to enter the quantities ordered. In other words,
the Orders table and form would have fields for Quantity Product 1,
Quantity Product 2, and Quantity Product 3. Is this a good idea or am
I missing something?
Thanks for any and all help.