Connecting two child databases?
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...
Forum Discussion
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?
Totally agree that Homeowner Contact Details should be connected the opposite way to Sales Appointments. What I was running in to though, is that I cannot do a combined text field of the Appointment Date, I get this error "That summary function cannot be applied to this field..."