F
Fernando
Hi there,
The background:
I have 2 tables: a Books table and a Publishers table. There is a
one-to-many relationship between Books and Publishers implemented with the
PublisherID as a foreign key in the Books table.
I have a Books form based on the Books table. The form is used to navigate
through the books in the database (via the navigation buttons at the bottom)
an to enter a new book in the database. I´ve created the form by droping the
fields in the Books table on the form in design view.
The form also includes a combo box which is bound to the PublisherID of the
Publishers table. The control shows the list of Publishers.
The problem:
I have 2 questions that I believe are related
1) when Inavigate through the book records with the Books form how do I
populate the combo box for the PublisherID with the correct publisher for
each record ?
2) when I enter a new book or update an existing one how I populate the
Books table with the PublisherID from the combo box ?
Thank you very much in advance
The background:
I have 2 tables: a Books table and a Publishers table. There is a
one-to-many relationship between Books and Publishers implemented with the
PublisherID as a foreign key in the Books table.
I have a Books form based on the Books table. The form is used to navigate
through the books in the database (via the navigation buttons at the bottom)
an to enter a new book in the database. I´ve created the form by droping the
fields in the Books table on the form in design view.
The form also includes a combo box which is bound to the PublisherID of the
Publishers table. The control shows the list of Publishers.
The problem:
I have 2 questions that I believe are related
1) when Inavigate through the book records with the Books form how do I
populate the combo box for the PublisherID with the correct publisher for
each record ?
2) when I enter a new book or update an existing one how I populate the
Books table with the PublisherID from the combo box ?
Thank you very much in advance