Discussions

Expand all | Collapse all

Adding company to a contact record then display on a report

  • 1.  Adding company to a contact record then display on a report

    Posted 06-28-2019 19:27
    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?


  • 2.  RE: Adding company to a contact record then display on a report

    Posted 06-28-2019 21:49
    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.