Hi I want to use DR and DF for a multipage order system but dont want to bloat the messy User Profile table with a bunch of order fields.
I know how to write a standard INSERT query for a completion event but would rather have this as a Stored Procedure. Im not sure on how to make this with the $(xxx) tokens that the shortnames in the form use.
Do you have an example on a very simple SP that references the UserID as a foreign key and UPDATES/INSERTS field data into a flat table? Even if its just 1 or 2 example fields, I can work from that.