Discussions

Expand all | Collapse all

Can you have a button in a table to create a new record in a none related table

  • 1.  Can you have a button in a table to create a new record in a none related table

    Posted 05-11-2017 18:10
    I have 2 table that are not related.  Can I create a button in Table 1 to add a record in Table 2?


  • 2.  RE: Can you have a button in a table to create a new record in a none related table

    Top
    Contributor
    Posted 05-11-2017 18:15
    Yes

    Do you want it to create the record without even going there?  or do you want to go to the new table and a new form to confirm info and save?


  • 3.  RE: Can you have a button in a table to create a new record in a none related table

    Posted 05-11-2017 18:48
    Go to the new table form


  • 4.  RE: Can you have a button in a table to create a new record in a none related table

    Top
    Contributor
    Posted 05-12-2017 05:07
    Make a formula url field.

    Use something similar to this (your variables will change)

    URLRoot() & "db/" & [_DBID_TABLE_2] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Field I want to Pre fill])& "&_fid_8=" & URLEncode ([another field I wand to pre fill])& "&z=" & Rurl()

    If you don't want the redirect back to the origin, remove the & "&z=" & Rurl()
    at the end.

    If you have more info of what you are trying to have it right, and some fields that need to be written to, let me know and I can help with syntax if needed.