1 on 1 tables?

[hbrems]

Hello,

suppose I have a table with 3 persons:

- John
- Kate
- Rudolf

and suppose that I have a table with 3 types of fruit

- Apple
- Orange
- Banana

How can I make sure that when John takes the apple, it won't be visible for Kate and Rudolf, until John 'releases' the apple?

In other words, the apple would disappear in the combobox until John 'releases' the apple.

Kind regards,
Hans B.

 

[KenHigg]

Do you really want an apple after someone else has handled it?

 

[RuralGuy]

Have you used the "Not IN() clause before?

 

[hbrems]

Have you used the "Not IN() clause before?

Actually no, and how would it be applicable in this case?

 

[neileg]

The problem of using ficticious examples is that it masks the real business process going on. Sometimes the right answer is not the answer to the question you are asking!

The answer depends on how you are linking the tables. If you holf the ID of the person 'owning' the fruit in a field in the fruit table, then a query based on the fruit table that uses a criterion of 'IsNull' in the person ID field will return only the fruit with no current owner.