Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
8 years ago

Actions ""Add New Record"" to table with same Key field

I've been using Actions for a while.  I have observed is that if I choose the "Perform Action Type: Add New" and the value am inputting into the Key Field of the table where the new record is created ...
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

If you edit an existing record, you look to [Date Modified] for the date of last modification. The field [Date Created] will never change once populated. Anything after that is an edit.

With the QB Actions, to create a New record in the manner you're describing, leave off he [Record ID#]. The database will always provide a new ID number to this field itself. You would only provide a new ID# to a custom Key Field.