M
MWE Owner
Hello everyone,
I am making a database with a customer table which has 3 seperate
tables in to reduce memory (i.e. a table of title's, mr, miss, blah
blah blah)so you select the title from a drop down list.(customer ID
primary Key)
Then I have 2 tables with the product details in (i.e. 2 completely
seperate products, that in the end become 1)(product ID in both is
Primary Key)
then I have a table link with Customer, & the products(s) they have
orderd with Order ID as primary key
Now I want to make a form, that says all of the customer details, &
when you change record, in a sunform, it says exactly what they bought
AND how much it all costs
how do i do this
(note in the product tables, a price has been listed, as in product a.
costs £8.00 & product b. costs £10, so in the form i want the subform
to have a "total cost" column)
thanks everyone
I am making a database with a customer table which has 3 seperate
tables in to reduce memory (i.e. a table of title's, mr, miss, blah
blah blah)so you select the title from a drop down list.(customer ID
primary Key)
Then I have 2 tables with the product details in (i.e. 2 completely
seperate products, that in the end become 1)(product ID in both is
Primary Key)
then I have a table link with Customer, & the products(s) they have
orderd with Order ID as primary key
Now I want to make a form, that says all of the customer details, &
when you change record, in a sunform, it says exactly what they bought
AND how much it all costs
how do i do this
(note in the product tables, a price has been listed, as in product a.
costs £8.00 & product b. costs £10, so in the form i want the subform
to have a "total cost" column)
thanks everyone