Hello,
I have a 3-tier database (grandparent, parent and child), which I would like the end user to be able to navigate using command buttons.
Currently, I know how to add command buttons using the event builder that can open another form, and at a specific record. So far so good.
However; there are 6 grandparents, 9 parents, and approx. 40 children. Not all parents are related to all the grandparents, and not all children are related to all the children. My current buttons display on a form for all records, including those which do not relate to the record the button will open.
I have set up the many-to-many relationships between each generation/tier.
From the grandparent/parent forms, I would like to have command buttons allowing you to go the next level down, to the parent/child related to the grandparent/parent record displayed.
As I scroll between records, I would like for these buttons to stay the same, but their attached events to change.
I'm imagining this should be possible somehow using the relationship join tables and/or record ID numbers.
If this downward journey is possible, it follows I could go up the family tree in a similar manner.
For Example: From Grandparent 1, I want to be able to open the parent form at records 1 or 3. From Grandparent 2, I want to be able to open the parent form at records 2 or 3. The grandparent form would then only need 2 or 3 buttons.
Likewise, from Parent Form record 1, I would like to be able to go the Child form, and open records 1, 2, 3, 4, or 5 etc.
From Parent record 9, I would like to be able to open Child form, record 35, 36, 37, or 38....
Many thanks in advance,
Tom
I have a 3-tier database (grandparent, parent and child), which I would like the end user to be able to navigate using command buttons.
Currently, I know how to add command buttons using the event builder that can open another form, and at a specific record. So far so good.
However; there are 6 grandparents, 9 parents, and approx. 40 children. Not all parents are related to all the grandparents, and not all children are related to all the children. My current buttons display on a form for all records, including those which do not relate to the record the button will open.
I have set up the many-to-many relationships between each generation/tier.
From the grandparent/parent forms, I would like to have command buttons allowing you to go the next level down, to the parent/child related to the grandparent/parent record displayed.
As I scroll between records, I would like for these buttons to stay the same, but their attached events to change.
I'm imagining this should be possible somehow using the relationship join tables and/or record ID numbers.
If this downward journey is possible, it follows I could go up the family tree in a similar manner.
For Example: From Grandparent 1, I want to be able to open the parent form at records 1 or 3. From Grandparent 2, I want to be able to open the parent form at records 2 or 3. The grandparent form would then only need 2 or 3 buttons.
Likewise, from Parent Form record 1, I would like to be able to go the Child form, and open records 1, 2, 3, 4, or 5 etc.
From Parent record 9, I would like to be able to open Child form, record 35, 36, 37, or 38....
Many thanks in advance,
Tom