Main Form updates Sub-Form and associated table?

[Maxwell Britman]

Hi,

I have a little problem that I can't get my head round.

Tables:
customers - CustomerID, Forename, Surname......... ProductName, Model,
Brand.... other product related info.... etc

orders - OrderID, CustomerID, ProductID, UnitPrice, Quantity, Date
products - ProductID, CategoryID, ProductName, UnitPrice

Forms:
main form - customer and primary product details
sub form - orders datasheet showing secondary accessories bought

I can currently select primary product on main form via combo box, but
would like to add it to orders table and have it updated on orders
subform. Orders subform and ability to add orders via product
combo-box in itself is working fine.

Primary product may change or be upgraded at some point by customer
which is why current primary product has to show next to customer
details AND be added to orders table when bought/upgraded.

Question, would it be better to add field CurrentPrimary to customers
table linking to either products or orders table thereby allowing
'remembrance or recall' of what is the primary product?

Any ideas?

Max

 

[Maxwell Britman]

Hi,

I have a little problem that I can't get my head round.

Tables:
customers - CustomerID, Forename, Surname......... ProductName, Model,
Brand.... other product related info.... etc

orders - OrderID, CustomerID, ProductID, UnitPrice, Quantity, Date
products - ProductID, CategoryID, ProductName, UnitPrice

Forms:
main form - customer and primary product details
sub form - orders datasheet showing secondary accessories bought

I can currently select primary product on main form via combo box, but
would like to add it to orders table and have it updated on orders
subform. Orders subform and ability to add orders via product
combo-box in itself is working fine.

Primary product may change or be upgraded at some point by customer
which is why current primary product has to show next to customer
details AND be added to orders table when bought/upgraded.

Question, would it be better to add field CurrentPrimary to customers
table linking to either products or orders table thereby allowing
'remembrance or recall' of what is the primary product?

A 'Duh' moment overcame me. It's late so someone go ahead and sue me.

I've already added ProductID to customers table and forgot about it,
so the last paragraph can be ignored for now. Sigh! Sleep? Whats that
then?