Hi Guys,
Appriecate your help to resolve my query.
My setup is as shown below.
Main table Columns
1. Name
2. Location
3. Owner
4. Address
5. Suburb
6. Postcode
7. Rego
8. Expiration Date
Lookup Table 1 Columns
1. State
2. Subburb
3. Postcode
4. Location
Lookup table 2 Columns
1. Model
2. Rego
3. Expiraton Date
I'm using a excel file to upload data to my dataverse main table which has information related to Name, Location, Owner and Rego columns. I'm looking for a method to update rest of the column information while referecing to the lookup tables.
1. Using the " Location " value on the table to lookup to table 1 and update same row with Suburb and Postcode
2. Using the " Rego " vaule on the main table to lookup to table 2 and update same row with Expiration Date
Thank you.
