stuartb
Posts: 1
|
| Posted: 01/19/2004, 1:22 AM |
|
Hi all,
Using CCStudio, PhP and MySQL.
I'm building an application that has two main tables, call them "people" and "organisations", that have a one-to-one link. I've created a form that allows maintenance of the "people" records with a ListBox that selects the appropriate "organisation" record, and all works well.
But now I want to default fields on the "people" form with values from the selected "organisation" record, and I don't know how to go about it.
I realise it will mean a refresh of the form, as at the start when the form is first displayed we don't know which organisation record to use. However I haven't got an idea how this could be done. Any help to point me in the right direction would be great.
Many thanks
Stuart
_________________
Stuart Box
Burningsuit Ltd
|
 |
 |
Alejandro
|
| Posted: 01/19/2004, 2:15 PM |
|
Why donīt you divide the form in a two step process, first for entering own values like name, etc and a second one to correct organization related values?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/19/2004, 2:38 PM |
|
I suggest using JavaScript to automatically submit your form when the value of the ListBox changes:
http://www.google.com/search?q=%22submit+form%22+javascript+onchange
I guess you could have the ListBox in a separate Form or the same one.
The rest depends on your form structure. For example if the ListBox ("organisation") contains the key to your form/record, then probably the form will be refreshed automatically with the matching values. Otherwise you may use the BeforeShow event using the CCDLookup function:
http://docs.codecharge.com/studio/html/Components/Funct.../CCDLookUp.html
http://docs.codecharge.com/studio/html/ProgrammingTechn...gleDBValue.html
Or custom code with SQL:
http://docs.codecharge.com/studio/html/ProgrammingTechn...leDBValues.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
