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

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?

0 5 430
5 REPLIES 5

@Nick_Parsons1 wait for my email

Thank you…

Alex_Meraru
Participant III

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

field.

am also looking forward to the solution…

@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.

Top Labels in this Space