Is it possible to produce a form along the lines of the attached image ?
I know some parts are possible as I've looked at the videos but I'm not sure if all is possible. So any pointers, ideally to a similar example , would be good.
I see it working like this:
This form sits on a page with text above and below. I can handle this.
Part 1 of form
A combo box is filled from an external table view which has a bound field ( hidden ) giving a client number and then displays detail about the client - Company, Contact name and Ledger Balance. I can fill a combo - based on the video tutorial.
When the user select an item from the combo Parts 2 and 3 are displayed using the combo bound field - ideally via Ajax so that the rest of the page does not refresh. Not sure about this !
Part 2 of Form
Full Address (multi-line text box) on LHS with 3 fields on RHS e.g Phone, Email, Web Address. This is a 2 column display. I know you can do this via Groups but I haven't found a 2 or 3 column form example.
So far all this data could come from a MySQL view - the combo string and the detail for the text boxes below.
Part 3 of the Form
This will come from a client contact table detailing each activity relating to the client. This information should be as a normal list with view and amend buttons. The list should contain a selection of elements and the form which is displayed when the view or amend icon is clicked should, if possible contain additional elements - i.e the list is a sub-set of the elements displayed on the form.
As with a normal list and add new button should be present to allow addtional client contact entries to be added.
A mock up of the form is attached.
Is this possible ? Or if not, where do I have to compromise ? If so any help to get me started would be appreciated.
Thanks
Peter
I know some parts are possible as I've looked at the videos but I'm not sure if all is possible. So any pointers, ideally to a similar example , would be good.
I see it working like this:
This form sits on a page with text above and below. I can handle this.
Part 1 of form
A combo box is filled from an external table view which has a bound field ( hidden ) giving a client number and then displays detail about the client - Company, Contact name and Ledger Balance. I can fill a combo - based on the video tutorial.
When the user select an item from the combo Parts 2 and 3 are displayed using the combo bound field - ideally via Ajax so that the rest of the page does not refresh. Not sure about this !
Part 2 of Form
Full Address (multi-line text box) on LHS with 3 fields on RHS e.g Phone, Email, Web Address. This is a 2 column display. I know you can do this via Groups but I haven't found a 2 or 3 column form example.
So far all this data could come from a MySQL view - the combo string and the detail for the text boxes below.
Part 3 of the Form
This will come from a client contact table detailing each activity relating to the client. This information should be as a normal list with view and amend buttons. The list should contain a selection of elements and the form which is displayed when the view or amend icon is clicked should, if possible contain additional elements - i.e the list is a sub-set of the elements displayed on the form.
As with a normal list and add new button should be present to allow addtional client contact entries to be added.
A mock up of the form is attached.
Is this possible ? Or if not, where do I have to compromise ? If so any help to get me started would be appreciated.
Thanks
Peter