But what if you want to add one parent record and multiple child records? Here's how it is done using our same ... data first into the Jobs table. The Jobs table uses JobID as the primary key field.