Populating table from search

  • Thread starter Thread starter Maxwell Chow
  • Start date Start date
M

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?
 
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?
Click to expand...

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