Announcement

Collapse
No announcement yet.

SC Form app insertion

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SC Form app insertion

    I aware default Form app required to select a particular TABLE in order to insert into DB when "Save" button clicked.
    Is there away to insert into multiple Tables without writing additional PHP code?

    E.g.
    Form App: form_employee
    To be INSERT tables
    - emp_emergency_contact
    - emp_dependents
    - emp_job_details
    - emp_contacts

    how to save into multiple table by click 'Save' in SC (without writing any custom events or codes)

    Thanks for the clarification.

  • #2
    Originally posted by weilies View Post
    I aware default Form app required to select a particular TABLE in order to insert into DB when "Save" button clicked.
    Is there away to insert into multiple Tables without writing additional PHP code?

    E.g.
    Form App: form_employee
    To be INSERT tables
    - emp_emergency_contact
    - emp_dependents
    - emp_job_details
    - emp_contacts

    how to save into multiple table by click 'Save' in SC (without writing any custom events or codes)

    Thanks for the clarification.
    If all needs to be done from one form then the only way would be using an event and additional php. But if you have more detail records you would still run into trouble. So the only way I can think of (lookin at your sample) is using master-detail forms or separate forms within a container or just separate forms with links / menu's. Depends on your needs and wishes.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      thanks for the reply and any tutorial which can achieve this?
      those i found are quite general (sorry if i missed out)

      Comment


      • #4
        If you go to scriptcase.net then video's then search for master detail you will find an instruction video. Other video's might be interesting too although it will take some time to view them all.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment

        Working...
        X