G
Geoff Jones
Hiya
Can anybody help me with the following?
I have an Access Database. There are two tables in it. tblCustomers and
tblOrders.
tblCustomers:
Customer_ID
Customer Address
tblOrders
Order_ID
Customer_FK
Product Ordered
There is a one to many relationship between the two tables.
How can I generate the orders that a given customer has made? I do not wish
to modifty the database in any way. All that I need to do is generate the
results as another table.
I know how to do this using DataTables, a DataSet and Relationships.
HOWEVER, I'm wondering if there is a QUICK way to do this using an SQL
command; ideally without creating DataAdaptors.
I'd be most grateful for any help and example code.
Many thanks in advance
Geoff
Can anybody help me with the following?
I have an Access Database. There are two tables in it. tblCustomers and
tblOrders.
tblCustomers:
Customer_ID
Customer Address
tblOrders
Order_ID
Customer_FK
Product Ordered
There is a one to many relationship between the two tables.
How can I generate the orders that a given customer has made? I do not wish
to modifty the database in any way. All that I need to do is generate the
results as another table.
I know how to do this using DataTables, a DataSet and Relationships.
HOWEVER, I'm wondering if there is a QUICK way to do this using an SQL
command; ideally without creating DataAdaptors.
I'd be most grateful for any help and example code.
Many thanks in advance
Geoff