Unanswered: Help needed look up from 2 tables at once.
Hi Any help would be greatly appreciated.
i need to make database which is a basically a book library system. In one table I have Members info (MemberID, name, address, postcode etc) and another one with bookID, title, author, publisher.
i want from a form for the operator to be able to enter both sets of info on one form into a new table which keeps a record of which membeers are borrowing which books. One othe rproblem is how can i just select one field such as member ID and have the rest of the fields automatically filled in from this info ?
Im sure theres a simple solution but its been buggung me for ages !
If you want the user to enter datas and to let Access handle that, you'll have to use sub-form. First, make sure your relation are okay, create your form on MEMBERS and a sub-form of BOOKS. This will allow you to modify information. Using a query will also work, but you'll only be able to look datas (well, you could still do it manually...)