I have a database where one table has a foreign key matching an auto-incremented index in another table. I want to use a Base form to add a record to both at once, automatically including the foreign key for the new record in the second table. Is this possible?
Simple illustration: Table A has six rows, and table B has four rows. In a single form entry and without knowing either number, I want to add rows that look like this:
A B
+----+------+-----------+ +----+-------------+
| id | b_id | name | | id | content |
+----+------+-----------+ +----+-------------+
| 7 | 5 | blah blah | | 5 | yadda yadda |
+----+------+-----------+ +----+-------------+