Hello,

I've need help for a project for school :(....

I've got two combo-boxes. Its is btw a database for a library. I've got 4 tables:

When people lend a book, you can view this on the lend_form
Are people going to lend a new book, the operator must be able to select the ISBN or the Title of the book...

I just can't fix that problem. I don't have a lot experience with Access and VERY LITTLE TIME :( that's why i ask your help!

Books
- book_id
- book_author_id
- book_name
- book_isbn
- book_amount

Authors
- author_id
- author_initial
- author_insertion
- author_surname

Customers
- customer_id
- customer_name
- customer_insertion
- customer_surname
- customer_address
- customer_zipcode
- customer_recidence
- customer_phone

lends
- lend_id
- lend_customer_id
- lend_book_id
- lend_date

Thanks a lot guys,

Erik.

You don't really describe a problem in your post so I can only guess at what your problem is.

If you're trying to use "cascading" combo boxes, where a change in one changes the other, then you should do a search of this forum for "cascading combo boxes". There are lots of examples out there.

Thanks... i will do.... i could get on the right name... :)

Have a look at this example of cascading combo boxes. If you need any further help with your database I have a good example of a book/author database. If you want to have a look at this send me an email as this database has a lot in it and I can't attach it here due to the size. Here's the cascading combo sample in the meantime.

HTH
Hay

Hey Hayley! Can you post a copy of that database in Access 97 format please? I'd really appreciate it.

Thanks!

Vassago

Here you go then Vassago.