Populating table from search

[Maxwell Chow]

I have a form that returns search results from table tblProperty I would
like to populate another table with select records from that search. This is
a kind of shopping cart function. What I want to do is keep a list of
properties that are shown to each client.

tblClient linked to tblViewing via ClientID
tblViewing linked to tbl ViewingList via ViewingID
tblViewingList linked to Property via PropertyID

I have tblClient as a main form(frmClient) with tblViewing as a
subform(frmViewing).
tblViewingList is a subform(frmViewingList) in frmViewing.

As of now I can add properties to frmViewinglist, but I would like to be
able to do this from records I select from the search results.

Any ideas?

 

[John Vinson]

As of now I can add properties to frmViewinglist, but I would like to be
able to do this from records I select from the search results.

Any ideas?

An Append query using the same criteria as your search will do this.