J
Joe
I have a simple database (Access 97) that contains two tables - 'Client'
which contains demographics and has as its key a unique ID number(Client_ID)
and 'Service' which contains user input data and a common field of Client_ID.
There is a one to many relationship between the two tables with client_id as
the connecting field.
My main form contains the information from the client table and the subform
contains fields for user input and some calculated fields. A report is
produced from a combination of information from both tables.
My problem: When a client id number is entered in the search field the
subform is automatically populated with previously input records. There is an
exception in that records where the client's maiden name has changed due to
marriage etc or where there is a change of address are not automatically
retrieved and so there is a possibility of lost data for that client. It is
a requirement that the service table contains data lastname and address as
there is a need to monitor these areas of change for this particular database.
Link Child Fields:
client_id;last_name;given_name;title;birth_date;address;gender
Link Master Fields:
client_id;last_name;given_name;title;birth_date;address;gender
I have tried just using the Client_id field in the link fields but lose all
the other demographics in the header when I print out the report.
Question: How can I get the subform to be populated by -all- records
related to the Client_id?
ps sorry for the long post.
which contains demographics and has as its key a unique ID number(Client_ID)
and 'Service' which contains user input data and a common field of Client_ID.
There is a one to many relationship between the two tables with client_id as
the connecting field.
My main form contains the information from the client table and the subform
contains fields for user input and some calculated fields. A report is
produced from a combination of information from both tables.
My problem: When a client id number is entered in the search field the
subform is automatically populated with previously input records. There is an
exception in that records where the client's maiden name has changed due to
marriage etc or where there is a change of address are not automatically
retrieved and so there is a possibility of lost data for that client. It is
a requirement that the service table contains data lastname and address as
there is a need to monitor these areas of change for this particular database.
Link Child Fields:
client_id;last_name;given_name;title;birth_date;address;gender
Link Master Fields:
client_id;last_name;given_name;title;birth_date;address;gender
I have tried just using the Client_id field in the link fields but lose all
the other demographics in the header when I print out the report.
Question: How can I get the subform to be populated by -all- records
related to the Client_id?
ps sorry for the long post.