SC Form app insertion

Applications Forms
#1

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

[QUOTE=weilies;24283]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.[/QUOTE]

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.

#3

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

#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.