probing table to see if a number already is used?

[stann]

Hello

I have table called "lane" and it has a field called "Lane NUMBER"

I need to make a button that probes another table "REG" and specifically a field called "Lane "AssignmentREG" to allow that number to be registered ONLY if it has NOT already been used.

Any suggestions are very helpful . I can understand I have to do some kind of find. But I want to automate this and ALLOW my old script to work UNLESS the number is already in a record on the other table.

HELP

[CobaltSky]

Hi stann,

I suggest you create a relationship between the 'lane' and 'REG' based on a match between the Lane NUMBER and AssignmentREG fields, then test whether the current number in Lane NUMBER exists in the REG table with:

IsEmpty(REG: AssignmentREG)

...which will return a 0 if the number has already been used and a 1 if it is an unused number.