help with recordset join
Need a little help with a recordset query. I have 2 tables and want to search both of them.
table1 is my sales table (each order is a row in this table)
The orderID is Primary key.
table 2 is my sales_detail table (each item in the shopping cart is a row in this table)
The foreign key references the orderID in the sales table.
I have done an inner join between the two tables.
I then want to do a search on both tables. But the results always show me every line in the sales details table. so i end up with duplicate information in the recordset results once the search is done.
How do i show only 1 row for each order without the duplicate info?