Skip to main content

Rent equipment by lot or by unit

  • June 18, 2019
  • 3 replies
  • 67 views
C

Hi there,

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.

Trial #1
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.

Trial #2
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!

    This topic has been closed for replies.

    3 replies

    JonathanBowen
    Forum|alt.badge.img+18

    Hi @Claudia_Leduc - does this work for you?:

    I have an “items” table and a “lots” table:

    Lots and items are linked. I’ve also got a “rentals” table where you can choose an item to rent OR a lot to rent:

    With some lookups, rollups and formulas on the Items and Lots tables, I can show when an item has been overbooked at the item level (same item twice), at the item + lot level or the same lot twice.

    You can also see if an item or lot is currently rented (“not available”) or not.

    Hope this helps

    JB

    C
    • Claudia_Leduc
    • Author
    • Participating Frequently
    • July 23, 2019

    Hi @Claudia_Leduc - does this work for you?:

    I have an “items” table and a “lots” table:

    Lots and items are linked. I’ve also got a “rentals” table where you can choose an item to rent OR a lot to rent:

    With some lookups, rollups and formulas on the Items and Lots tables, I can show when an item has been overbooked at the item level (same item twice), at the item + lot level or the same lot twice.

    You can also see if an item or lot is currently rented (“not available”) or not.

    Hope this helps

    JB


    Wow, thanks a lot Jonathan. Will definitely look into this!

    C
    • Claudia_Leduc
    • Author
    • Participating Frequently
    • July 23, 2019

    Hi @Claudia_Leduc - does this work for you?:

    I have an “items” table and a “lots” table:

    Lots and items are linked. I’ve also got a “rentals” table where you can choose an item to rent OR a lot to rent:

    With some lookups, rollups and formulas on the Items and Lots tables, I can show when an item has been overbooked at the item level (same item twice), at the item + lot level or the same lot twice.

    You can also see if an item or lot is currently rented (“not available”) or not.

    Hope this helps

    JB


    Ho this is great, I helps me a lot!
    Thanks so much JB!

    Claudia

    Terms & ConditionsAccessibility statement