Hi,
I'm trying to create a database for our training department to use to generate joining instructions for training courses. So far I have created the form generally as I want it to look and it does almost everything I need it to except for one thing.
I want the user to select the hotel name from the list and for the appropriate hotel address details to populate in the appropriate fields. I thought a table lookup would be simplest for this and would keep the design of my form relatively simple as this will be printed as their joining instructions. Someone recommended I use a sub form for the hotel info but a) I couldn't get that to work and b) I didn't like the appearance it gave the document.
I've attached the database to give a better understanding of what I'm trying to do. Can anyone help?
Thanks,
TC
I'm trying to create a database for our training department to use to generate joining instructions for training courses. So far I have created the form generally as I want it to look and it does almost everything I need it to except for one thing.
I want the user to select the hotel name from the list and for the appropriate hotel address details to populate in the appropriate fields. I thought a table lookup would be simplest for this and would keep the design of my form relatively simple as this will be printed as their joining instructions. Someone recommended I use a sub form for the hotel info but a) I couldn't get that to work and b) I didn't like the appearance it gave the document.
I've attached the database to give a better understanding of what I'm trying to do. Can anyone help?
Thanks,
TC