Skip to main content
Question

Adding company to a contact record then display on a report

I am creating an inspection report. I have three tables:

Contacts
Companies
Report

I know how to create a contact and relate the company and pull that into the contact information. However, when I try to relate that contact information to the report table, from the relationship between contacts and companies I cannot get the related information (Companies) to pull over. I have tried several different relationships at this point and I am stuck. What am I missing?
    This topic has been closed for replies.

    Can you clarify your relationships.

    Is it

    1 Company has many contacts
    1 contact has Many reports.

    If that is your structure, the. If you want Company info on your reports, then do lookup fields down to Contacts and then again new lookup fields from contacts to Reports, so a double hopper lookup.
    Terms & ConditionsAccessibility statement