this scenario like this.
tbl_client tbl_partner_employee tbl_partner_business
id(PK) id(PK) id(PK)
name job_company business_company
address position business_field
partner_name
job
partner_employee(FK)
partner_business(FK)
the form is like this:
name:textfield
address: textfield
partner_name: textfiled
job : dropdownlist consist employee and business
when employee dropdownlist job is select, the form tabel partner_employee is show up, and vice versa.
how I can make it?
I have read forum for 2 days and never get the answer, there is nested forum and it look like need save the form 1st then save 2nd form which I want save all form at once and dynamic form that I don,t understand.
or maybe I just put in all field in 1 table and make some filter to show up the field that I want?
but what the code?