Three queries. One Form.

Hi, I am trying to make one form on a single page insert info into three tables; query 1 creates an art_id (auto-increment) for the newly created row in table art; query2 creates a media_id in table media. Then I need to get the art_id and media_id created by the first two queries to insert into an intersection table as query three. Must I run an intermediate query to get the ids, and assign it to vars? What would it even look like? Thanks in advance,