Insert page, 2 tables & 1 'stages' form.
Good morning, this may sound confusing so please bear with me!
I want users to add sales leads to our database, currently have tblCases & tblContacts which holds this information. On the Cases insert page I can pull the contact through to assign to case by using dynamic dropdown but I want to make this more user friendly.
I have a wizard style form, each step is a simply div with 'Next', 'Previous' & 'Finish' buttons.
Step1 - tblContacts.php
Step2 - tblCases.php
Step3 - Insert/Finish
Step1 a tblCase.CaseID would be created, I would like the users to either select a current contact or be able to add a new contact to case. If current that contacts data should be auto filled onto form, ie address, phone etc.
NEXT button -->
Step2 the form will contain data to be inserted into tblcases along with ContactID from above.
INSERT / FINISH button -->
Can I join the 2 tables above to allow data to be inserted into both, if so would I be able to split 1 form that collects this data into 2 parts [Contact + Case Data]?
Is it possible to have the ContactID details auto inserted into form fields when a contact is selected from Dynamic menu?
Many thanks once more.