I have two table with ID field relations. Just one is portal table in the main table.
I excute finding in main table , of course getting the searching result. But how to diplay all the portal record within this finding?
You can make a Global field in your main table, and then setup a self relationship between the Global and your record IDs. Use the "List of" type field to create a Summary of your field IDs. Put that list of values into your Global ID field via script, and your Portal that references the self relationship will show the found values. There are other variations on this technique but that is the basic concept.
Sorry, I am fresh with filemaker. Would you please give me more detail?
I only want to show all related portal record with this finding .
How to script it step by step？
Thank you very much.
A find on a layout with "parent" (main) records and a portal ("child") records will return the parent records and show the portal records.
From this "parent", you can use a script step (put into a button)
Go to Related Record
There are several options in the dialog, so pay attention carefully. For example: Do you want to just show the related children of the current record or all the related children of all the found parent records?
If your find really is for all the children that match a criteria as well, you may wish to rethink your find. Can you post more details, please?
Hi Beverly, thank you for your proper reply.
Yes, I make a found set in parent table , but also want to show all child records.
Show ALL child records of ALL matching parent records., this is my plan.
If I use GTRR function, may I achieve this plan when finding some records manually in parent table ?
It is pleasure to give me some advice from you when I click button with GTRR script.
In the previous post beverly gave you the thing you are looking for. GTRR using the found set. It is all in the GTRR setup dialog.
I'm helping you by encouraging you to:
1. find your records by script or manually
2. put a button on your layout (at the top in the header part?) and make it a script step for Go to Related Records
3. when the dialog(s) appear to set that up, take a screen shot and post it here
4. we can help you by pointing to the things to change in the dialog to achieve what you need.
I'll like you to study the help topic (previously posted) and look closely at the dialog(s) when you set the step. You might figure it out or we can use your screen shot to be very specific on what to do.
Set up dialog attached below. Then what steps should take , or only check "match all records in current foundedset" ?
Would this check know current found set in parent layout?
1st - change the "Get related records from" to be Jobs (whatever the portal relationship is called)
2nd - change the "Show records using layout" to be one that is based on the related child records (list or form views, though list would show more at once), which would be something based on Jobs.
If the table Jobs and layout is in a separate file, then you may need to check the "Use external table layouts"
3rd - Result options:
a. "Show in new window" is optional and may or may not be used here. Don't check this just yet
b. check "Show only related records" &
"Match all records in current found set"
4th click OK and test the script.
Come back if this did not work as you thought or you have more questions.
p.s. you will NOW be in a different set of records than the parent. You can show parent fields on this layout as desired. And you can have a "reciprocal" Go to related record back to your found set of parents!
Thank you very much！ I will try later then give you feedback.
Retrieving data ...