Topic: Write to multiple tables
This is for a simple debit/credit entry but I'm not sure it can be done.
I either need to write two entries to the same table on the same form where each entry properly links to a parent account table. I don't think this is possible because there's no way to tie specific fields to specific parent tables.
OR
I need to write two entries to two different tables using the same form. I don't think this is even possible because the SAVE RECORD option requires you to select ONE table to write to.
Can either one of these be done?