Create subform in form linking to two different tables

[fboehlandt]

Hi everyone,
I would like to create a bibliography in access. So far, I have the following:

Table SOURCE
<Authorname> <Article> <Journal> <Year>

Table AUTHOR
<First Name> <Middle Name> <Last Name>

I would like to create a form to enter new data with the four fields of Table SOURCE. A new entry should trigger a subform for Authorname that allows users to type in First Name, Middle Name and Last Name. That data should then be saved in the second table AUTHOR. Authorname in Table SOURCE should be in the following format:

<Authorname>
Kennedy, J.F.

whilst in Table AUTHOR it would look as follows:

<First Name> <Middle Name> <Last Name>
John Fitzgerald Kennedy

can anybody give me some pointers? I have no idea how to implement this. Cheers

 

[John Big Booty]

I'm not sure you need three tables two tables should do the trick. It's just a matter of storing the authors name as First Name, Middle Name and Last Name, in you Authors table and and linking that to your source via an Author ID and then manipulating the data at the point it is displayed on the form with something like;

 [ALName] & ", " & Left([AFName],1) & ", " & Left([AMName],1)

Have a look at the attached DB, perhaps that will help.