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?

Re: Write to multiple tables

This is possible only using the script and SQL queries.


I hope this topic will be helpful
http://myvisualdatabase.com/forum/viewtopic.php?id=459

Dmitry.