Updating two tables

Hi,
I use Form Maker and have mapped the fields to a table I created (Club Details) This works, all club details are inserted into the table.
The query looks like this:

INSERT INTO clubprofile (ClubID, ClubName, ClubDescription, ClubCountry, ClubWebsite, ClubEmail, ClubTel, StreetName1, StreetName2, ClubCity, ClubProvince) VALUES (“”, “{2}”, “{13}”, “{9}”, “{14}”, “{3}”, “{15}”, “{4}”, “{5}”, “{6}”, “{7}”)

Note that the ClubID is a auto number field in the table and the value is set on insert.

Now I need to add details to a second table that is used to link the logged on user to the club.
The query I created looks like this:

INSERT INTO adminclublink (AdminClubLinkID, ClubID, UserID, IsAdmin) VALUES (“”, “{1}”, “{userid}”, “{true}”)

AdminClubLinkID is a auto number field in the table and the value is created on insert.

I need to find a way to retrieve the ClubID that was just created in the first query and add the value to the second query.
I also need to set the IsAdmin value to true but is does not work the way I set it up – “{true}”

Any help would be appreciated
Thanks

https://wordpress.org/plugins/form-maker/