shopping basket in Access?

[OceansideDaxx]

I have created a catalog DB. Users can search the DB by entering partial or keywords. The user can double click the search result and a form will show the product details. Now, is it possible to add multiple search results together, similiar to a shopping basket in an online store, and generate a report? And Allow users to view the products they have selected? Help!!

 

[erroldou]

Interesting question

Hi,
Not sure if this would work, but you could try using a make-table query to store the results of your first search, then use an append query to append the new data for each search.
This way, when your user is finished they can view all data from their numerous searches.

Cheers,
Errol