Skip to main content
Question

Connecting two child databases?

  • August 8, 2019
  • 0 replies
  • 27 views
I have three tables. Canvassing Leads which creates records in Sales Appointments and Homeowner Contact details. Now I need to grab the appointment day and time from Sales Appointments and put them in to Homeowner Contact details. 

I guess the issues is is that I don't know how to make Sales Appointments update the correct Homeowner Contact, which got it's info from Canvassing leads. Here's my relationship diagram. 


    This topic has been closed for replies.

    Are you sure you have that bottom relationship correct? It seems to me that Home owner contact should have many sales appointments. Your diagram shows it the other way around? Can we first sort that out?
    Forum|alt.badge.img+11
    • IvanWeiss
    • Quickbase Alumni
    • August 8, 2019
    Just another general note, is the table homeowner contact details?  I would think the table is homeowner with fields that have the contact information.  

    You probably could use a report link since canvasing leads is the common denominator here.
    Terms & ConditionsAccessibility statement