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?
@Nick_Parsons1 wait for my email
Thank you…
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |