I have three tables. Called Author, PublicationRelation and Publication. The relationships are, (one-to-many) and (many-to-one) respectively.
PublicationRelation has the foreign keys(AuthorID and PublicationID)
Want I would like to do is to have a form based on the Publications table. When a user enters in a new Publication the PublicationID is entered into the PublicationRelation. This is achieved with a Subform with a link to the PublicationID. However Want I would also like to do is to have another subform where the user chooses the UserID and this also is updated into the PublicationRelation field under UserID.
Is this possible to be done?
Thanx for any suggestions
PublicationRelation has the foreign keys(AuthorID and PublicationID)
Want I would like to do is to have a form based on the Publications table. When a user enters in a new Publication the PublicationID is entered into the PublicationRelation. This is achieved with a Subform with a link to the PublicationID. However Want I would also like to do is to have another subform where the user chooses the UserID and this also is updated into the PublicationRelation field under UserID.
Is this possible to be done?
Thanx for any suggestions
