billythedj66
Board Regular
- Joined
- Jan 6, 2003
- Messages
- 126
I am working on a database in Access 97. I have a form which the user can input in various fields. The problem I am having is one of the fields (Room Numbers) is from a different table, and I don't know how to make the field save to the other table. It only allows the user to choose from existing Room numbers. Is there a way I can add new room numbers without setting up a sub-form?