Table Relationship Linkage

N

Nagster

I am preparing a database to track financial and food assistance applicants.
I have four tables: Applicant personal info, applicant dependent info,
applicant household finances, and a table to track the specific dependent's
requests for Christmas gifts. I cannot figure out how to link the tables as
subdatasheets specific for each applicant; the sub datasheets end up
containing successive information for each successive applicant. How do I
keep two other applicant tables dependent upon and singular within the
applicant personal info table. And how can I do the same for the applicant
dependent table and the dependent Christmas gift requests? Oh, by the way,
all this needs to be done by TODAY!!!! Thanks
 
J

John Vinson

I am preparing a database to track financial and food assistance applicants.
I have four tables: Applicant personal info, applicant dependent info,
applicant household finances, and a table to track the specific dependent's
requests for Christmas gifts. I cannot figure out how to link the tables as
subdatasheets specific for each applicant; the sub datasheets end up
containing successive information for each successive applicant. How do I
keep two other applicant tables dependent upon and singular within the
applicant personal info table. And how can I do the same for the applicant
dependent table and the dependent Christmas gift requests? Oh, by the way,
all this needs to be done by TODAY!!!! Thanks
Click to expand...

Subdatasheets - indeed, datasheets themselves - are of VERY limited
utility. If you have two one-to-many relationships (Applicants to
Applicant Dependents, and Applicants to Household Finances) then
subdatasheets will NOT be able to handle what you want.

Instead, use the powerful tool that Access provides: the Form. Create
a Form based on the Applicant table; put a Subform on it (using the
subform wizard) based on the Dependent table; a second subform based
on the Household Finance table, and so on.

Could you explain your table structure? What is the Primary Key of
each table, and how (if at all) are the tables related in the
relationships window?


John W. Vinson[MVP]
 
Top