Friends,
My database has 5 different tables (tbl1, tbl2, tlb3, tbl4, and tbl5)
with the same fields: ID, SSN, LNAME, FNAME, RECEIVED and CLOSED. The
ID is the PK and its autonumber.
Obiously different data is stored in each table according to the type
of work my office handles. The database is used for a small insurance
company.
I have created a form on which added subforms each of which has it's
record source to a different query based on each of the above tables.I
give criteria to these queries using a form:
forms![myform]![mytxtbox]. It works fine. The form opens and displays
all the subforms with its data (SSN, FNAME, LNAME, RECEIVED and
CLEARED).
Since I would like not to repeat data like SSN, FNAME or LNAME more
than once, I was thinking of a way to display this information only
once. The problem is I could use one subform as the master one to
display the SSN, FNAME and LNAME, adn the other ones to display all
the other information, but it could be that that specific table (tbl1)
does not have that data but this has only been stored in tbl2 and
tbl3.
I believe the only way I can do this is using a query based on all the
5 tables an setting the criteria to the SSN again. But still cannot
get it working.
Can any one help me with the solution?