2 Replies Latest reply on Dec 11, 2013 6:25 AM by disabled_dconnect

    How to add x into blank field when new record created?

      Title

      How to add x into blank field when new record created?

      Post

           Hi,

           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.

           Thanks.