LO 6.3, HSQLDB, Mac OS Mojave
New user here, did some minor work with MS Access years ago, now creating a project for a work friend
Simple(ish) database - Guests Tbl (Guest_ID, Name , etc) RentalEquipment tbl (Equipment_ID, Description, Price)
I can show the Guests on mainform and their Rentals on a subform of mainform however no updates,deletions,additions are allowed to subform as it’s greyed out - I understand this to be because I am using a query to extract from the two information tables.
I have tried using just SQL commands and also tried using a junction table, the junction table method allows updates/changes (as the + is not greyed out and I can manually type changes although I need them to be from a drop down list of the Equipment tbl to prevent user error and misinformation being entered)) to the existing information. I want to add to the Rentals for a particular Guest just the items from a specific list of items on the Rental ItemsTable and not allow free text to be typed in and then once the added/changed/deleted information is entered for the subform to update itself
Initially if someone could give me a pointer in the right direction as to whether to use a junction table or some other method to achieve this I would be most grateful - a very brief example would be extremely helpful.
Guests information should be updateable to rent NONE, 1, or MULTIPLE items at the same time
Thanks in advanceDive_Guests.odb