Re: How to create a new record button in a form to another table

URLRoot() & "db/" & "xxxxxxxxxxx"
& "&_fid_10=" & URLEncode([field 1])
& "&_fid_11=" & URLEncode([field 2])
& "&_fid_12=" & URLEncode([field 1])

// this last line is optional and will cause the user to land on the record or report they started form when clicking as opposed to the newly created record.
& "&z=" & Rurl()


// xxxxxxx would be the table id code that you see in the url when on the target table.

------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------