I have three tables set up in my database. Caseworker Information, Client Information, and Mail Log. What im trying to accomplish is :
Step1 on caseworker information form...Enter the municipalities that the worker supports. <----- I did this by setting a value list and having check boxes.
Step 2 Once case worker is enrolled go to the client information section. Within the client information form... Have a drop down list of municipalities. select the manicipality the client lives in <---- I did this with the same value list that i used in step1 for manicipalities.
Step3 Once selected on manicipality...I have two other fields on the client form.. Caseworker code which is the primary key in the Caseworker Table and another field case worker full name.
Now what i want to do is... after selecting the municipality for the client... have two fields... Case worker Name and Case Worker Number. The case worker number field would be sorted by the selection of what manicipality you selected . For Ex. If say Mr Smith did manicipality A and Mrs. doe did manicipality B. An within the form you selected manicipality A. Then Mr. Smith would be the only one to show up under the caseworker code section. After the case worker code section is filled in...i would like the case worker name section to automatically populated from the field caseworker code...since everycase worker has a unique number.. Please help ive spent 5 hours on this and drank 3 red bulls and cant figure out what scripting to do on this? Thanks
attached to this message is a screen shot of the relationships. Thanks again. Ray Z