Hi, i think I'm starting to get to grips with access but I'm stuck or possibly do something the wrong way.
I have produced all my tables for my room data sheets (i only have 2, one for general room information which contains unique text or yes/no check boxes and the second for equipment which will be within each room) but i am now a little stuck with the room information input form (my main form which will allow users to input the data for each room and add or delete existing rooms).
Within my room information input form i have the room number and name at the top and have tabbed pages for each section of the room data sheets, piped services, wastes, power and comms...etc. I haven't had any problems setting these up so far and all seem to work fine.
I now need to add the relevant equipment which will be within each room. I have created a separate table for each piece of equipment with the relevant information eg name, manufacturer, size, required services...etc. I would like a tabbed page within my room information input form which produces a drop down list where i can select a piece of equipment (from my equipment table) and type in the quantity of that piece of equipment within the room, once i have selected a piece of equipment i want it to produce a second drop down list where i could add a second or third if required.
Currently when i insert the table it does just that and gives me a list of all the items within my equipment table. This tells me i should not be importing the table but I'm not sure what i need to produce (table, query,form)
Any help would be greatly appreciated.
And apologies for confusion in my explanation and any errors in nomenclature.