Match Child Records to Parents
I just imported two tables of data from Salesforce, one for Accounts (parent) and one for Building Data (child). Each Account has a unique Account ID and the matching Building Data records includ...
Forum Discussion
:)
Just set the Key field of the Accounts Table to be the Account ID field. Then make the relationship and use the similarly named field on the child when you make the relationship.
Just set the Key field of the Accounts Table to be the Account ID field. Then make the relationship and use the similarly named field on the child when you make the relationship.
Now that I changed the key field to a text field, how can I automatically create new Account IDs going forward so that users don't have to manually enter something unique every time?