I have a drop down calendar field in a portal, attached to a date field in a table.
It works well with all records having different dates.
When I click on the new record button to add a blank record it changes all the date records to the latest record or the last one edited. Obviously this creates a problem.
There is nothing in the script attached to the new record button that relates to the date field. the button does the following -
Go to Field [ChartAccounts::AccountName]
Insert Calculated Result [Select; ChartAccounts::O_Pac; Funding::PacCode]
.....there couple of other insert calculated results fields just prepopulating some data and then finish with...
Go to Portal Row [Select;Last]