No announcement yet.

Form from multiple tables

  • Filter
  • Time
  • Show
Clear All
new posts

  • Form from multiple tables

    Hello guys, I need some help.

    Is there a way to have a form collect/insert data into multiple tables?

    Scenario is easy: Entity table has multiple phone numbers and multiple emails. Just need a form where you can insert a new user/entity where fields like name, last name and others are filled and show at least one form field for 1 email and 1 phone number. When inserting the form has to insert into the three tables.

    Then I need to show up a Master/Detail where the master shows the names, and when clicked it shows all contact info + all emails + all telephones.

    Is there an example I could use?

    Thanks in advance !!!

  • #2
    You can only generate a form on one table. But you can add custom fields. In the onafterinsert/update you can insert/update your other tables by coding it yourself. Not very complicated, the sql can be generated by the sql builder and the code snippets can help you a lot.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development /


    • #3
      And for grids "Views" are your friends

      Professional Scriptcase Services
      Some Customers opinions


      • #4
        Thanks for your help. I kind of got to the same conclusion, but wanted to be sure before keep trying to "figure it out".