Submitting different values
Posted: Fri Mar 07, 2008 9:26 am
Hello Board...
I have been successful in running a query to put values into a list for the user to choose from in a form. However, I don't want that value entered into my table, I want its corresponding id value.
For instance: table1 has "apples" with id=1, "oranges" with id=2, etc... My other table has a field "fruit_id" where it equals table 1's id (one-to-many relationship). The question is: how do you get it to submit the id value?
My form is already set and can submit data into my database, this is the only piece I'm missing.
Thanks
I have been successful in running a query to put values into a list for the user to choose from in a form. However, I don't want that value entered into my table, I want its corresponding id value.
For instance: table1 has "apples" with id=1, "oranges" with id=2, etc... My other table has a field "fruit_id" where it equals table 1's id (one-to-many relationship). The question is: how do you get it to submit the id value?
My form is already set and can submit data into my database, this is the only piece I'm missing.
Thanks