I have a Quote Header/Quote Detail scenario.
*Quote Header:The unique identifier in the header is QuoteID and its set as the key of the header table with the initial value set to UNIQUEID().
*Quote Detail: I have the line items associated with the quote and of course the quote_id with REF to Quote Header and IsPartOf set to yes.
I was entering items to the quotes with no issue but now when I input line items it doesn’t record the quote_id from the Header into the Quote Detail spreadsheet (GoogleSheets) so the records are orphaned.
I was just testing the project to turn it over to the client. What would cause this to happen?
Thanks for the help.