Forum Discussion

MontgomeryHepne's avatar
MontgomeryHepne
Qrew Cadet
6 years ago

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?
Relationships
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.