I need to organize rental of equipment by lot and by unit. The use of the lots are to make it faster sometimes to rent a batch of equipment that is often rented together. The difficulty is that the units in the lots can also be rented by unit (the units can be divided).
I’m having trouble wrapping my head around this. I have tried to 2 solutions, none being really satisfactory.
To start with, I have a table for the Equipment and one for the Rentals.
In the Equipment table, I created a “Lot” field and filled it for each item of equipment.
The problem with this configuration is that I can’t find a way to select the lot from the Rentals table and that I have to add every unit of the lot one by one.
I created a table for the Lots and linked it to the Equipment table with multiple entries.
Then I added a field Lot in the Rental table. The problem in that configuration is that I didn’t find a solution to make sure we would know in the Equipment table what units are then rented.
I hope this is clearly explained, it’s always hard to take a step back when you’re elbow deep in the project.
Do not hesitate to ask precisions if needed.
I would love to hear from you guys!