Simple Dynamic Rule Question
I am having a bit of a problem building a dynamic rule. I have a basic app, 2 tables. LOCATION and WALK. The location table is basically 2 important fields - Site and Area... Site would be the ...
Forum Discussion
To me, it sounds like you need to setup a conditial dropdown
Site and Area should be pulled out in to Tables of their own instead of fields on a single Table.
Then Relate Sites can have many Areas
Then Location can go away. (I don't think you'd need it)
To Confirm, when you say
"The relationship is one LOCATION to many WALKS."
Would it be the same to say a Walk can have many locations?
If so, Then you should also do Walks can have many Sites & Walks can have many Areas.
Then use the Conditional Drop Functions of the Key Field (Related Area) of the Relationship between Areas and Walks.
You could then you Related Record ID's to Filter Forms.
IF the Related Site 1 and Related Areas related to 1 are say (3,8,10,12)
Show these Questions, and so on.
I'd be happy to schedule a meeting with you to discuss how all of that would work.
IF a Walk can have multiple sites, I'd also venture to say you probably need to create a Many to many relationship setup.
So in addition to the conditional drop down you would also create a Table Called something Like Site - Walks.
And relate the Table Walks to Site- Walks where Walks can have many Site-Walks
and relate the Table Sites to Site-Walks where Sites can have many Site-Walks
This "Joining Table" Would Function as the Main table your users use, and the other tables would operate more in the background.
This would allow you to create many Walks that are variabled based on Which Sites and Which Areas are addressed in a single walk.