Qrew LegendNo problem,
Just create a Report Link field on the Projects table. You don't need to have a relationship. Just configure the Report Link field on the left side with [Related Company] and then configure the right side by selecting the application .... (watch out for a popup blocker) and then locate the [Related Company] field on the Contacts table. Put that Report Link field on the Projects form and set it to display the records directly on the form.
Thank you so much! I didn't know about the Report Link field. I am not seeing how I can set it to display the records directly on the form, right now I only have a hyperlink. Could you provide some guidance?
Qrew Legendnp, on the old or legacy form style, just edit the FORM Properties to display the Contact records directly on the form. There is a radio button for that.
Thank you! Is there no way for it to work on the new forms?
Qrew LegendIt will definitely work in new forms too. I'm not a "pro" yet on those, but try this:
Make an unfiltered Report of Contacts to be used for the embedded report of Contacts. call, it Used on Project form
Then put a "Report Component" on the Form and then select that report and then set the form element to filter the form element with your Report Link field.
