I have a 3 levels relationship company > contact > Event. I want to see all the events of a company in the company form

  • 0
  • 2
  • Question
  • Updated 4 years ago
  • Answered
I have a 3 levels relationship company > contact > Event. there is a company > contact relationship and a contact > Event relationship. The database is already full of records.

In the event company I can see the name of the contact and the name of the company through a contact-company field.

But I now need to be able to see all the events for a given company. If I create a new relationship between company and event, the link will be empty.

Any idea how to automatically get the link between the company and the event ?
Photo of Patrice

Patrice

  • 10 Points

Posted 4 years ago

  • 0
  • 2
no problem (except that we seem to have a spam attack going on)


When you make a Relationship QuickBase makes a Report Link field, so people assume that you need to have a Relationship to have one, but that is not the case.

So just bring down a lookup of the [Related Company] down to the event record from the Contact record and call it [Record ID# of Company].  I suggest not to call it [Related Company]  as it is not in fact related.

Then go to your Company table and make a report link field and configure the matching between the [Record ID#] of the company record and the [Record ID of company] down in the events table.
Photo of Patrice

Patrice

  • 10 Points
Thank you, I appreciate your time, but I am not sure I get it. Maybe I can explain little bit more

I have plenty of events filled related to contacts, not to company. But they are in the Event for I can see the contact and the company, but these fields come from the contact record.

I now need to go to the company record above the contact, and see all events.

There is no existing relationship between company and event yet, and event table is full of records. If I create a relationship with events and companies, the link will be empty unless I correct one by one all existing records (hundreds).

Is that more clear ?
It was totally clear for the beginning.  Was my answer clear?   I edited it slightly, please re-read it and then let me know if you have a question about my solution.  You do not need to have a relationship between Events and Companies.
Photo of Patrice

Patrice

  • 10 Points
Thanks for your caring. It may either be my understanding of English or QB...

I am not sure what "bring down a lookup" means. I have an existing relationship from Events to Contacts that has a link with the company (automatically called "contact - company). But I cannot get the record # of the company apparently.

If it is not what you mean, I do not understand what means to bring down a lookup. Could you help more ?
I may have misunderstood the one to many side of your relationships can you say your relationships and explain the one and the many?
Photo of Patrice

Patrice

  • 10 Points
Actually after few tests, I just got it now.

a) I added a lookup on my exisiting contact>Event relationship, in order to add the Customer Record Id. After that I got it into my Event record

b) I created a new field, Report Link field, and "manually" set the field relationship to the  Event - Contact - Company - Record ID, and it worked

You are brilliant. Thanks for your great help !!!
Great, the magic is that you don't need to have a relationship to have a report link field.
Photo of Patrice

Patrice

  • 10 Points
definitely !!

This conversation is no longer open for comments or replies.