In the database I have created I am collating information such as equipment details for multiple equipment on the one form. I want to be able to put this into a table so that it can be reported on;
Fields are
Equipment Type - Make - Model - Serial Number
Then the user can chose what equipment type via a combo box & manually enter the remaining formation. So what could possibly happen is that there could be 3 type of equipment located at the one address. How can I then link this information to a table for each individual item?