I am working on an app that tracks expenses incurred during trips. A trip can include one or more Customer(s). So, there is a one to many relationship between the trip (one) and customer (many) tables.
I would like to be able to create first create a Job (call it Job 1). From within the Job 1 record, I’d like to be able to add Customers. I have 3 worksheets that contain: Jobs, Customers and Job/Customers, with relations between Jobs and Job/Customers and between Customers and Job/Customers.
Once I have created Job 1, I would like to be able to press a Add Customer form button where I can simply select a Customer from the Customers table using a Choice component.
So, from Job 1, I’d like to be able to add Customer A, Customer B, Customer C, etc.
Is there a way to simply select Customer A, then (using the same button) select Customer B, etc. - without also having to select Job 1 every time? The entries being made go to the Job/Customers table as:
Job ID Customer
Job 1 Customer A
Job 1 Customer B
Job 1 Customer C
How do I set this up so that the Job 1 side of the entry is automatically passed over to the table?