Topic: Restrict field entry to one per user
Here's what I have:
A User Table
A Housing Table linked to the User table.
A field in the Housing table with a choice of residence of Full Time, Part Time or Investment
-
I would like to make it so that for a specific User, they can only have one Full Time Residence.
They might have a part time cabin and some rental houses, but only one can be their Full Time Residence.
-
I'm thinking that an IF statement looking for a Full Time entry in the users Housing records would be used to allow or disallow a second Full Time entry.
-
I have a rough idea about the code but I'm not at the level yet where I can write it myself.
-
As always, your help will be appreciated.
Thanks, Frank