I have three tables: tblClient, tblRegion and tblCategory. The tblClient has foreign key relationships with tblRegion and tlbCategory. I want a web form, where the client can select a region and a category, from a drop-down combo box, which are populates with the values from the related tables i.e. tblRegion preferably shows the Region however, I want to insert the RegionID into the Client table and likewise with the category table.
How do I populate the drop down combo boxes? How do I get the record ID for the selected entries and write this in the insert statement?
Any help at all gratefully appreciated