M Costumes
Member
- Local time
- Today, 03:03
- Joined
- Feb 9, 2021
- Messages
- 75
Before I even try to figure this out, I thought I'd ask if this is even possible. I'd like to create a Main form and a Sub form for managing a rental. The Main form would be based on a table of rental details (who the client is, the dates, etc.) The Sub form would be based on a rental inventory table. Both sets and individual items can be rented out. I'd like for the user to be able to select/enter the set number in a combo box on the Sub form, and it automatically generate rows/records of the individual items in that set. Is that possible without basing it on a query? I need the information to be stored, which is why I don't think I want to base the Sub form on a query. Thanks for your thoughts!