jeremie_ingram
Registered User.
- Local time
- Today, 07:42
Here what I hope to acomplish.
I have a DB with 3 tables in it that have forms to add/modify data. These tables are.....
tblTourny
tblDiv
tblMem
They have a one to many relationship in that order (1tourny - ManyDiv / 1Div - 10Mem&Rank)
What I need to do is create a fourth table to house the data from these relations and a simplistic form setup to allow for the data entry. Heres the catch - there can be MISC data for both the Div and Mem tables.
I have attempted cascading combo boxes, but that didnt work out. I attempted a subform structure that I couldnt get straight, and now I am working out multiple forms but am failing in passig the selections from one to another.
Can anyone out there "see the error of my ways"? Any and all suggestions/criticisms are welcome. If someone could point me in the right direction I would truly appreciate it.
Note: I have searched these forums for "tournament", "variables", "passing variables", and a few others. I have found some ideas, but not quite what I was hopeing for.
I have a DB with 3 tables in it that have forms to add/modify data. These tables are.....
tblTourny
tblDiv
tblMem
They have a one to many relationship in that order (1tourny - ManyDiv / 1Div - 10Mem&Rank)
What I need to do is create a fourth table to house the data from these relations and a simplistic form setup to allow for the data entry. Heres the catch - there can be MISC data for both the Div and Mem tables.
I have attempted cascading combo boxes, but that didnt work out. I attempted a subform structure that I couldnt get straight, and now I am working out multiple forms but am failing in passig the selections from one to another.
Can anyone out there "see the error of my ways"? Any and all suggestions/criticisms are welcome. If someone could point me in the right direction I would truly appreciate it.
Note: I have searched these forums for "tournament", "variables", "passing variables", and a few others. I have found some ideas, but not quite what I was hopeing for.