Matching Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a database that matches the values in 2 tables off against each other and records the details of the match in a third table. I have worked out a system for setting this up but I am falling down at the user interface for the matching

A lot of the matching will require the user to look at values in each table and match them off. To enable them to do this I know I need to set up a form with 2 sub forms so they can look at records in each table. I then want them to be able to click the appropriate lines for matching and click an update button.

The problem I have is enabling the users to be able to select lines (single and multiple) in each table and then find what their selection is with code so I can run the matching system I have on their selections

Cheer
 
Maybe you could use multi-select list boxes instead of subforms to show the
records from the two tables... then it would be quite easy to do the rest in
code.

HTH,
Nikos

DNF Karran said:
I am trying to set up a database that matches the values in 2 tables off
Click to expand...
against each other and records the details of the match in a third table. I
have worked out a system for setting this up but I am falling down at the
user interface for the matching.
A lot of the matching will require the user to look at values in each
Click to expand...
table and match them off. To enable them to do this I know I need to set up
a form with 2 sub forms so they can look at records in each table. I then
want them to be able to click the appropriate lines for matching and click
an update button.
The problem I have is enabling the users to be able to select lines
Click to expand...
(single and multiple) in each table and then find what their selection is
with code so I can run the matching system I have on their selections.
 
Back
Top