I get this error: Key field "Employee ID" ca...

(Nick Parsons) #1

I get this error:

Key field “Employee ID” cannot be blank, when adding a new record in a form.

I think it’s because Employee ID is the ref field also.

If I don’t have this as a ref im not sure how to ref the tables?

(Levent KULAÇOĞLU) #2

@Nick_Parsons1 wait for my email :slight_smile:

(Nick Parsons) #3

Thank you…

(Alex Meraru) #4

I hope I’m not wrong as I am a beginner but you can’t have the key column as ref.

The key must be unique.

Add a new column as the key [key] and write UNIQUEID() in the Initial value


(Thomas Varghese) #5

am also looking forward to the solution…

(Aleksi Alkio) #6

@Alex_Meraru You can have a ref field as a key column, but then you can have only one record with the same ref. That’s why there is no sense to use it as a key.