Scenario: I have 3 data-blocks: a, b, c.
data-block a has 3 items: customer_number, customer_name, account_id
Dataflow: In data-block a, the user enters a customer_number. This will automatically populate items customer_name and account_id (if the account_id already exists in the database) as well as the other two data-blocks (b and c). HOWEVER, if the account_id doesn't already exist in the database, the user must enter one, and once it's entered it's implicitly saved, and the next time the user logs in the account_id will already be in the database.
Question: How do I implement this logic? What kind of triggers should I use?
Thank you.