Unique Values and Boolean Fields

[Triad]

"I was wondering if it's possible to make a LookUp field only accept duplicate values, provided the boolean field to all other duplicates are checked."

The duplicate values would be the ItemID whereas the Boolean field refers to whether the Item has been returned or not.

So this means the Item can only be hired out again IF it has been returned.

-Hope this makes sense, I'm not an expert on Access either so please can I be given clear instructions, I am using Microsoft Access 2000.

Thanks in advance.

[Access_Blaster]

"I was wondering if it's possible to make a LookUp field only accept duplicate values, provided the boolean field to all other duplicates are checked."

The duplicate values would be the ItemID whereas the Boolean field refers to whether the Item has been returned or not.

So this means the Item can only be hired out again IF it has been returned.

-Hope this makes sense, I'm not an expert on Access either so please can I be given clear instructions, I am using Microsoft Access 2000.

Thanks in advance.

If you are using a Y/N checkbox, you can use a query to filter records that have the box checked which are -1 or unchecked boxes which are 0. Hope this helps.

Richard