Director database

help with database in director

[estebones]

My client wants a database done in Director, I have done much research and I am still dumbfounded<?sp?>

a. I have a set of fields(3) that are where I plan on entering the data, they are labeled: medication, diagnosis, and sideeffect.

b. I have a submit button where the text entered in each field is to be placed into a proplist which will be inside another proplist

c. At Onmoviestart I have a blank proplist started : meds1=[:]

d. I cant figure out how to set the properities for each value(#medicaiton, #diagnosis and #sideeffects) so that when I push the submit button the information form each field(medication, diagnosis and sideeffect) can be set to the proplist so that it reads:
meds1=[Cogentin=[#medication:"cogentin",#diagnosis:"Parkinsonsdisease",#sideeffects:"blah"]]
no wait thats not it...
I also cant figure out how to pull a certain proplist and put it into a field, per say: if the user enters Cogentin into a field and clicks on the submit button I need a script to search on gmeds1 for the cogentin proplist? then once it is have it put into a field "results" in a legible manner.
Sorry for the long question but I have lost a LOT of sleep over this and cant figure it out.
So any help on how to make this work would be really appreciated.
ps I hope I have not confused anyone
Esteban

[korkus2000]

I really have no idea. Have you found any info?

[estebones]

No i dd not :(
Sadly I had to go and greate some thing that resembles adatabase using html and javascript....yup it was a whole lot of coding and its pretty much functional and does what it needs to do however its not a database and i am still trying.
plain and simple I need php, perl or some other tyoe of scripting laguage..blah!