A further question on this subject.
Originally Said By: Jimmy Wu
For each of the tables you will use the Single Record Insert server behavior once. You can apply it 3 different times for the three different tables on the different fields being inserted.So for your example, you would set up a Single Record Insert server behavior for Province, and then one for City and one for Postcode and they'd each be set up to insert into different tables.
Hi Jimmy (or anyone who can help),
As my query is similar I thought I'd tag onto this thread. Hope that's OK?
So, in my case I'm inserting into two tables from the one form
The second table is all from hidden fields. I have no problem with that. The problem is that one field within the second table is to insert the first tables ID number which is being made automatically with the auto-increment. I want that inserted into table two as a foreign key
Table 1 = tableID
Table 2 = FKtableID
Is that possible?
Many thanks.
