Auto-select foreign key for multiple forms

Auto-select foreign key for multiple forms

Let's say I was taking inventory of the types of pools and elevators a bunch of hotels have. I have 3 tables: Hotel, Pool, Elevator. 1 hotel can have 0 or many pools, and 0 or many elevators. I'd like the user to be able to select the hotel once, then have that selection be the foreign key for the Pool and Elevator, so they don't have to select the Hotel from a dropdown for each record created in the Pool or Elevator table. Is this possible?