populate foreign keys in relational databases from insert record behaviour
I have an enquiry form which sends its data to two different tables in a Database. This is done by creating two insert record behaviours. The tables are - 'enquiries' and 'property_enquiries'.
The 'enquiries' table has 'enquiries_id' as the primary key and 'property_id' as the foreign key.
The 'property_enquiries' table has 'property_id' as the primary key and 'enquiries' as the foreign key.
When the enquiries form is submitted I want both foreign keys created.
Can I use the 'Manage relational table' server behaviour for this or will it require hand coding to achieve this?