How to add x into blank field when new record created?
I have two tables. One table is shown via a portal in the other table.
I can write new records into the table in the portal using the portal.
This table has 10 fields, but I only have 4 showing in the portal.
I want to add new records via the portal. I will fill out the 4 fields, and the other fields will have x in them.
I need this as the legacy of my database is that it has all blank fields filled with a x instead of just being empty.
I looked through the forum, but can only find more complicated auto populate advice for dates etc.
I just want fmp12 to make sure that when new records are created, if there are any fields that are not filled in, they automatically get x entered into them when the record is created.