Is there a way to get a form to auto-post? If...

(Martin Eidensten) #1

Is there a way to get a form to auto-post? If not is there another way to click once and

add a new row to a table with set parameters?

(Simon Robinson) #2

Can you elaborate?

(Green Gorilla) #3

If the new row is basically a copy of an existing row, you could use an action using the LINKTOFORM(), linking to a FORM view…

You can then specify using text, or column references, what you want each

column to contain. Then save this new record.

E.g.

LINKTOFORM(“Sales_Form”, “Sales”,[SalesID],“Sales.ItemNumber”, [Sales.ItemNumber], “Sales.PrivateOrBusiness”, [Sales.PrivateOrBusiness],“CopyOROriginal”,“Copy”)

So this links to a FORM view called “Sales_Form”, and places the SalesID value in the “Sales” column, places the sales item number and private or business selections into the relevant columns, and adds the word “Copy” into the CopyOrOriginal column.

Hope that helps?