G
Guest
Hi,
i want to create a price list table and a customer table. I can run a query
using primary/foreign keys to return customer details, qty ordered and price
to pay,and design a form to input data but this only works on the first
record.
How can i get the query/form to work with more customer orders?
price list
ID autonumber
price 1
price 2
price 3
Customer
Id autonumber
surname
forename
ect
qty of 1
qty of 2
qty of 3.
I am a novice in access so any ideas would be gratefull.
Bob
i want to create a price list table and a customer table. I can run a query
using primary/foreign keys to return customer details, qty ordered and price
to pay,and design a form to input data but this only works on the first
record.
How can i get the query/form to work with more customer orders?
price list
ID autonumber
price 1
price 2
price 3
Customer
Id autonumber
surname
forename
ect
qty of 1
qty of 2
qty of 3.
I am a novice in access so any ideas would be gratefull.
Bob