Ok I have three forms lets call them A, B & C. They are all different as to what they are tracking, but they all have a common data field in them – ‘location’.
Can I set up a form that would allow me to search for a specific location and display the results from the three forms A, B & C on the same screen?
What I am after is to search a location and find out what is there from the three forms.
If that is not possible is it a case of combining the three forms into one so I can do the search? I think that should be possible, but it will make the form very big to accommodate all the data fields
Roger
How about having a 4th form “Location” that has a one-to-many relationship to A, B & C? You could then search this form to find all occurrences of the Location in the other forms.
I shall give that a try, wasn’t aware that a search on a form would give results that way.
Roger
Nope, by setting up a fourth form I can get it to search, but it won’t search just the linked forms, it needs to be set to search ‘all forms’ and then it does, bringing in data from forms that are not at all relevant.
Roger
Ya, you can only search the current form or all forms. Searching is limited to searching fields of the parent form only. That is, you can’t build a search which will let you target child forms while searching the parent form. Obviously you can search directly in a child form because a child is form is also a parent form but without any children of its own.
Over the last 24 hours I have combined the three data forms into one and that is then searchable so I have sorted it.
Thanks
Roger
.
