Hello,
Scenario:
Three tables - main data, customers, delivery addresses
New entry:
Form View (table: 'main data'):
Step 1. When selecting Customer from ref dropdown (table: 'customers'), a new conditional dropdown field appears with selected customer's delivery addresses (table: 'delivery addresses').
Step 2. Adding new delivery address opens Form View (table: 'delivery addresses') where the first value is dropdown menu with Customers again (ref table: 'customers').
I need to again select the customer from dropdown, but I would like the app to grab the data which I already selected in previous step.
I tried with initial value, but no luck, as this record is temporary and not saved yet, if I understand correctly.
How could I approach this situation?
Thank you in advance.
Solved! Go to Solution.
Not possible as is. You'd have to save the first record first, then create the new address record, which can lookup the customer with a LOOKUP(MAXROW()) expression.
Not possible as is. You'd have to save the first record first, then create the new address record, which can lookup the customer with a LOOKUP(MAXROW()) expression.
Thank you, Marc.
Makes sense.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |