Create line item in field, reference it in child table

[dahchrist]

Hello -

I have a form that we are using for invoicing and invoice creation. MOST of the "Customers" of this app are preloaded earlier on when they sign an agreement. Some customers, though, purchase an item without going through the agreement process (it's a weird procedure, I know).

Basically, I have an Invoice table that has a one-many relationship with a Transaction table. The Invoice table also references a Customer table, a Bill To table, and a POC table. Here's the trouble... Not all Customers are responsible for their bill - sometimes their insurance company is; in these instances the Customer is Jane Doe, the Bill To is InsuranceABC, and the POC is John.Frank@Insurance ABC.

The current workflow is that anyone who is created as a Customer will have a billing profile created for them via bots (bot will take information from Customer table and input it into the Bill To table). The issue lies in customers who don't come through the traditional route. I see two potential options that might work, but I don't know how to implement...

The first option:

A "Joined" table of Customers and Responsible Parties. Somehow generating a referenceable list of all Customer Profiles and Bill To options to allow a user to choose from a conglomerated listing.

The second option:

User opens invoicing form, taps Customer, New AppSheet opens New Customer form (1:1) Completes the required information for Customer, Okay AppSheet saves this information as a line-item entry to the Customers table User taps Bill To, selects the newly created Bill To (which was automatically created by the new Customer form) The newly created Customer from above is available to choose (as the only entry) Bill To is a referenced table, but the Key for values is only different by a prefix (BILLTO-CUSTOMERUNIQUEID) User taps POC, selects the newly created POC (which was automatically created by the new Customer form) User taps Transactions, New AppSheet opens the New Transaction form (1:many) Completes and Submits Submits Invoice and automations run