Dynamically populated form for Insert?? It can't be this hard.
Ok, I give up. I've spent hours trying to figure something out that will allow me to do this and I'm sure it's basic php.
I have two tables already and I want to create a third that will include some information from the other two.
Mostly their, ID, Name, Image.
I will be matching one ID from each table and creating a match record. So, what I have so far is an insert form and behavior. That's all working fine.
Then I created two drop down menus that are dynamically populated from record sets. (That works great).
But now, what I need is for the ID and Image to follow along in the insert to the new table. Their image is already on the server, so I just need the image_name.jpg to be inserted into the new table.
I first thought I could use Dynamic Dropdowns. But it wants to use only the ID for values all the way accross and I can't figure out how to do it.
Then, I thought if I could create two hidden fields next to each drop down, then I could change the value of each as the dropdowns are selected. I can't figure this out.
I tried using server behaviors with no luck. I even tried an onChange Javascript.
I know that I am missing something. Really tired from studying Relational Tables, Joins, etc. Which was my first thought.
Is there a basic way to select a record name or id from a drop down menu of choices and have a couple of fields populate?
Any help would be appreciated.
Thanks,
TroyD