3 tables - form

B

bluesand4

Joined
Dec 12, 2005
Messages
2
Reaction score
0
Hi,

I have 2 tables that have a many-to-many relationship (Book and author). To implement this in access, I have created a junction table (bk_auth).

Tables:
Book ---- 1 to many -----> bk_auth
Author ---- 1 to many ------> bk_auth


Now, I want to create a form to add new books, with their author. How to do this?

I thank you all for your support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form and Sub form 3
Using combobox to update tables 2
Update Two Tables Using One Form Contents 0
Separate Form 0
Form based on many to many relationship 6
Forms to enter data 1
newbie needs help simple form 1
Junction table record from a form 1

Top