E
Edgar Thoemmes
I have a form (tblStockEntry) with a subform(tblBookEntry), it is a stock
entry form for books. Each book could have more than one author so I have
had to create a junction table(tblBook/Author) with bookid and authorid.
As users will be inputting many books, I want to keep each book on one line
so when then user inputs the books authors I have created a seperate form
(frmauthordetails) which opens on the Author text box onfocus event. This
form record source is the Author table. I want to find some code which when
the user exits the form it would add an entry into the junction table with
the current record on main forms bookid and the current authors id.
Can anyone suggest any way of doing this or an altenative solution?
entry form for books. Each book could have more than one author so I have
had to create a junction table(tblBook/Author) with bookid and authorid.
As users will be inputting many books, I want to keep each book on one line
so when then user inputs the books authors I have created a seperate form
(frmauthordetails) which opens on the Author text box onfocus event. This
form record source is the Author table. I want to find some code which when
the user exits the form it would add an entry into the junction table with
the current record on main forms bookid and the current authors id.
Can anyone suggest any way of doing this or an altenative solution?