I am building a fake library database in school and have encountered som problems. I want the library to be able to order severeal books from on retailer. That is i want many "booknumbers" to be on one ordernumber.
I am thinking of choosing the retailer in a combobox from which one want to order books. Then just showing the ordernumer and name of the retailer with a new table(or new form) where I can add products to a specific order.

Puh.... greatful for answer... somebody may know where i can find examples of how to do this.
(one table for retailer, one for order and one for orderrow)

I think Access Database by Roman, 2nd Edition, a O'Reilly publication ($24.95 retail) uses that as an example for the book.

The northwind.mdb database is an example of an order entry system.