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 that relates loan, correspondance, research requests, talks and exhibitions to a table containing contact details. Each contact needs to be able to have multiple records in all of these areas. Each time the user wants to add, for example, a loan, the user needs to be able to choose from existing contacts or add a new contact. I've tried using multiple subforms within forms but I'm having trouble gettin the data to obey its relationships and keep the correct numbering, especially in the loan section. Each loan has a single loan ID but may well have multiple items that share that ID. So you could have a contact with two loans (two loan IDs) and 5 different items on each.... A friend has sent me an example database to get me going but it scuppers out when I try for new records and I don't understand the code enough to correct whats going on! Please help!
Thanks
Dom
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 that relates loan, correspondance, research requests, talks and exhibitions to a table containing contact details. Each contact needs to be able to have multiple records in all of these areas. Each time the user wants to add, for example, a loan, the user needs to be able to choose from existing contacts or add a new contact. I've tried using multiple subforms within forms but I'm having trouble gettin the data to obey its relationships and keep the correct numbering, especially in the loan section. Each loan has a single loan ID but may well have multiple items that share that ID. So you could have a contact with two loans (two loan IDs) and 5 different items on each.... A friend has sent me an example database to get me going but it scuppers out when I try for new records and I don't understand the code enough to correct whats going on! Please help!
Thanks
Dom
