Hi all...

I have the following problem:

I have two databases which are related to eachother. DB one contains 5 different fridges as items. DB 2 is my main DB to record new entries for leasing one of these fridges to a new client. The fridges are linked to my main DB with a dropdown menu to be selected. My question is:

How can I prevent selecting a fridge that's currently allready leased to someone. Is there a way to do that? Perhaps by locking the leased fridge and diplaying a popup message?

Any help would be greatly appriciated!!

Thanx!

I suppose that the Lease database DB2 has a record for every time a customer leases a fridge, with a field for selecting the fridge that gets leased, which I will call 'FridgeName' and a date field that gets populated when the fridge returns. I'll call that one 'ReturnDate'

You could give each record a calculated field with the following definition:

[case( not isEmpty(ReturnDate) , FridgeName)]

Now use a value list that gets it's entries from this calculated field and Bob's your uncle!

Hope you get the idea,

Regards,

Ernst. (going to take a look in the fridge, thirsty)