MySQL: Populating 2 Tables with identical fields

DB Name: Catalog

Tables: Authors____Library
Fields: AuthID_____AuthID
FirstName___Title
LastName___Reviews


I have linked MySQL to Access and created a form for Data Entry. I would like to be able to populate both AuthID fields with one entry.

Form:

AuthID_______ First Name_________ Last Name________

and so on.

Is this possible? I decided on this route due to many Authors selling multiple books.

Any help would be appreciated.

Thanks.

Cal

I figured it out, MySQL needs Innodb tables to implement foreign keys.