Lookup from a lookup
My title is probably not very accurate, but I was not sure how to phrase my situation. I am creating an app that is used for Construction job scheduling. I have created a child table [Equipment] an...
Forum Discussion
Hi Montgomery,
If I understand your situation correctly, you would like to see an embedded report of the equipment for your job in your Scheduler record.
You can create a Report Link field in your Scheduler table to embed the same report that you see in the Jobs record.
1. Create a Numeric (reference proxy) field in your relationship between Jobs and Equipment and pass the Related Schedule field from the Jobs table to the Equipment table.
2. Create a new field in the Scheduler table and select Report Link as the Type.
3. Open the field properties for the new report link field and click the Select Target button in the field properties to configure the report link
4. Follow the prompts to select which table the data is in and which field you want to use to match on. You will select the field created in step 1 above.
5. Add the new report Link to your form. The Records in the Equipment list whose value in the Job - Related Schedule field matches the Record ID of the Schedule will now be displayed in your embedded report as shown below.
If I understand your situation correctly, you would like to see an embedded report of the equipment for your job in your Scheduler record.
You can create a Report Link field in your Scheduler table to embed the same report that you see in the Jobs record.
1. Create a Numeric (reference proxy) field in your relationship between Jobs and Equipment and pass the Related Schedule field from the Jobs table to the Equipment table.
2. Create a new field in the Scheduler table and select Report Link as the Type.
3. Open the field properties for the new report link field and click the Select Target button in the field properties to configure the report link
4. Follow the prompts to select which table the data is in and which field you want to use to match on. You will select the field created in step 1 above.
5. Add the new report Link to your form. The Records in the Equipment list whose value in the Job - Related Schedule field matches the Record ID of the Schedule will now be displayed in your embedded report as shown below.