Hi
I am looking for some guidance. I have two DB tables, the tables are as follows:
tblCounty
countyID (int) AgentID (int) CountyName(text)
tblAgent
AgentID(int) Name(text) Contact Number(text)
What i want to do is to use a Dropdown list control to retrieve all the county's from tblCounty then when a user selects a county from the list the agent linked with that county will appear on the same page in something like a repeater control. I am guessing this is possible just i cant figure out how to do it
Just to let you know i am new to .NET and might need a step by step process.
Any help would be welcome, Thanks in advance