basically im trying to make one for a shop, a members tbl (done) a book tbl (done) but im not sure on how to make the other tbl which keeps track on the books that each user has brought , it needs to be a forum where they type in their MemberNo it finds their details (name, address etc) then in a sub form you type the BookNo and it finds the details on the book and adds it to a tbl meaning that you have brought it. Does anyone know anything that might help me, i have read lots of tuts on it and everything, i just feel like .

Thnx