Html combo box to database record Id
- by LanguaFlash
I'm fairly sure there has to be a simple solution to my problem, but I am a new web developer and can't quite figure it out.
On my page I have a combo box whose values are filled from my database. When the user submits the form, how to I go about converting those values back to the record numbers in the database?
Up to now I have been just doing a sort of reversed lookup in my database to try to get the record's ID. This has quite a few obvious flaws and I am sure that there has to be a better way. I am used to MS Forms combo boxes where the record data and ID are never separated. But in the case of a web form, I have no way to do multiple columns in the combo box like I am used to.
Thanks!
Jeff