I am looking at copying date from 2 fields in one table to a new field when record added, example of what i want to do: Data is in “Table 1” “Field 1 (John)” and “Field 2 (smith)”
Need to copy Data to “Table 1” “Field 3 (John smith)” The user adds data to field 2 and field 2, when record added the data is merged and added to field 3 Can anyone advise as I keep failing? Thanks
Add this code in the "Before record added" event of Table 1. $values["Field3"]=[size="2"]$values["Field1"]." ".[/size][size="2"]$values["Field2"];[/size] [size="2"]FYI: Sorry, just realized that you should not post your question here, but in the "General questions" forum.[/size]