Forum Discussion
- ChrisChris9 years agoQrew Assistant CaptainYou will import into the Parent Customers table. You are correct that the lookups will update automatically into the related Projects table's records.
- ChrisChris9 years agoQrew Assistant CaptainYes, they will show as Text ( lookup ) not as Address data type.
- EvanLeith9 years agoQrew TraineeI'm not 100% sure that projects is the child of customers, but the customer name, email, phone #, etc. auto populates when I click a button on the customer table to create a new project. I added the address fields in the relationship page, but they aren't auto populating when I click the create project button.
- ChrisChris9 years agoQrew Assistant Captain
Yes, Project is child to Customers. Your provided screen shot is the evidence of that. Are we certain that all the Address components are all populated in the Customer records?
- EvanLeith9 years agoQrew Trainee
Then on the same page, down below to create a project from the customer table...
- EvanLeith9 years agoQrew TraineeAre you saying I need to include street 2 and country?
- ChrisChris9 years agoQrew Assistant Captain
When you click into the address lookup portion of the Address data field ( the first text area that has a magnifying glass at its far right ) Google will take what is typed in there and populate the Address field components. If Google does not populate that, you do not need to either.
- EvanLeith9 years agoQrew TraineeThis is a screenshot on the customers table, it is blank when I click the "add projects" button and go to the new project table, but the information like name, phone#, email, etc. do auto populate.
- ChrisChris9 years agoQrew Assistant CaptainI will test in one of my apps. The screen shot is not present BTW.
- ChrisChris9 years agoQrew Assistant Captain
Evan,
I have created the association in a test database with the Address data type and bringing in 1 to 3 lookup fields -- components of the Address field data type -- and it was successful.
I'd like to suggest deleting the lookup fields from the child table and bring in the Address data type components as lookups again.
Be certain that you are using the Address data type in Customers for the address information, and not just regular text fields.
You can use just the one main Address field component as a test of this effort, the one that does the Google search.
I feel that you may have some junk lookup fields in the child table. Click the + sign next to the lookup field and see if there is an associated Related Customer Address field that goes with it.