S
SVE
I am using Access 2003. My problem is a bit complex, so I will try to make
it as clear as possible.
First how the 4 pieces of data relates to each other:
Family 1 to many with Child
Child 1 to many with FA CH Qs
Fam 1 to many with FA FAM Qs
FA FAM Qs 1 to many with FA CH Qs
Tables:
Family has field called FAM ID (primary key)
Child has field called Child ID (primary key) and one called FAM ID
FA FAM Qs has fields called, FA FAM Qs ID (primary key), FAM ID
FA CH Qs has fields, FA CH Qs ID (primary key), Child ID, FA FAM Qs ID, and
FAM ID (if needed)
Existing form:
Form is based on a query composed of data from Child table and Family table.
Has a tab with the child information and a tab with the Family information.
Others too, but not really relevant for this. When in this form called
"Application", I can scroll through all child records and see their info, or
if I am on the Family tab can see the family data for that child.
New tab/form:
When viewing/entering data for a child's record in the existing Application
form, I need to be able to click on the new tab (called "FA") and create a
new FA FAM Qs record. This record's data will show up on the FA tab for any
child who is linked to that FAM ID. After completing the FA FAM Qs
information, when I click in a field from the FA CH Qs table a new record
should also be created in that table, but it should NOT show up when I go to
the other children's records that are related to that FAM ID.
I created a main form for FA FAM Qs and put a subform for the FA CH Qs
information and the FA FAM Qs data shows on each child's record beautifully.
The problem is that the subform shows the data for all the chidren in the
family not just the data for the child's record that is currently being
viewed.
This all stems from the fact that we have a document where the first 5
questions pertain to the family as a whole, and the rest of the questions
pertain to each individual child. There is a new document filled out every
year.
I hope I have made this clear enough. Thank you for all your help in advance.
it as clear as possible.
First how the 4 pieces of data relates to each other:
Family 1 to many with Child
Child 1 to many with FA CH Qs
Fam 1 to many with FA FAM Qs
FA FAM Qs 1 to many with FA CH Qs
Tables:
Family has field called FAM ID (primary key)
Child has field called Child ID (primary key) and one called FAM ID
FA FAM Qs has fields called, FA FAM Qs ID (primary key), FAM ID
FA CH Qs has fields, FA CH Qs ID (primary key), Child ID, FA FAM Qs ID, and
FAM ID (if needed)
Existing form:
Form is based on a query composed of data from Child table and Family table.
Has a tab with the child information and a tab with the Family information.
Others too, but not really relevant for this. When in this form called
"Application", I can scroll through all child records and see their info, or
if I am on the Family tab can see the family data for that child.
New tab/form:
When viewing/entering data for a child's record in the existing Application
form, I need to be able to click on the new tab (called "FA") and create a
new FA FAM Qs record. This record's data will show up on the FA tab for any
child who is linked to that FAM ID. After completing the FA FAM Qs
information, when I click in a field from the FA CH Qs table a new record
should also be created in that table, but it should NOT show up when I go to
the other children's records that are related to that FAM ID.
I created a main form for FA FAM Qs and put a subform for the FA CH Qs
information and the FA FAM Qs data shows on each child's record beautifully.
The problem is that the subform shows the data for all the chidren in the
family not just the data for the child's record that is currently being
viewed.
This all stems from the fact that we have a document where the first 5
questions pertain to the family as a whole, and the rest of the questions
pertain to each individual child. There is a new document filled out every
year.
I hope I have made this clear enough. Thank you for all your help in advance.