To submit to an Access database, your form needs to be based off a database (or you'll need a custom web service or custom code). You'll need to define your table relationships appropriately in the database and also in the form when you create it. If the 'id' is an auto id field in Access, and your relationships are defined correctly, the id should correctly populate through all the tables on submit.