Search results

Hi, thanks for reading this :) Basicaly I'm trying to redo our database at work and finding myself woefully underequiped for the task. I'm slowly picking up bits and bobs as I go along but the task I have to do seems very complex from where i am now! Here is the jist. I am making a database...

Mkay thanks. I'm pretty n00bish I'm afraid so I may need a little more than that. I'd intended to set up forms for all of the tables anyway. The loan form includes an option to search the contact table or add a new contact and details such as total items loaned, last due date,then a subform...

I am constructing a database which includes three tables containting contact details, loan details and enquiry details. I would like to be able to link the loan and enquiry tables to the contact table via the field contact ID. This would mean that one contact can have multiple loans and multiple...