Unique Record

[Guest]

Hi

I have a Form that uses look ups from three different tables to identify a single unique record entity. Building + Floor + Room. There are no duplicate Buildings. In the Form - how can add new room numbers and insure that they aren't duplicate numbers for this particular Building-Floor-Room number unique entity. Keep in mind that in the Room table the number 203 may appear dozens of times because it exists in other Building-Floor-Room entities. I can't just say that the Room number field has a no duplicates

I know in the table design for fields with a single table you can create a combination of fields and index them as unique but how can you do that across three fields residing in three different tables on a Form

Thanks for the help

djb

 

[Evi]

In Table Design press the Index button, type any name for your Index in the
first column eg UniqueRooms, choose the first field (Building) in the 2nd
column.
Go down one row. Type nothing in the first column and choose the next field
(Floor) in the 2nd column. Repeat for the third row.
Click on your index name and in the grid below, set Unique to Yes.
Evi

Hi,

I have a Form that uses look ups from three different tables to identify a

single unique record entity. Building + Floor + Room. There are no
duplicate Buildings. In the Form - how can add new room numbers and insure
that they aren't duplicate numbers for this particular Building-Floor-Room
number unique entity. Keep in mind that in the Room table the number 203
may appear dozens of times because it exists in other Building-Floor-Room
entities. I can't just say that the Room number field has a no duplicates.

I know in the table design for fields with a single table you can create a

combination of fields and index them as unique but how can you do that
across three fields residing in three different tables on a Form.

 

[Guest]

The three fields Building - Floor - Room reside in three separate tables. While I could set up a unique constraint on the Building, I can't on the Floor or the Room as the values for those fields can duplicate i.e. many buildings have second floors and many second floors have rooms 201, 203, etc.

How can a check for uniques across the combination of building - floor - room?

djb