I am in need of your suggestion before starting my new project.
I like to develop in ASP.NET 2008, BackEnd MySQL
Project: ERP for an insurance company having many branches
In Agent master page: new agents will be registered and
In New business form: we have to show all agents in this form
Currently there are more than 1,00,000 agents available in DB.
While creating a new business/policy i have so show all agents in that form
from which client will select one agent who made the business.
like this: Agent list is necessary to show in many forms.
What is the best suggestion for showing this agent list (contains more than 1,00,000 agents)
Note: the same list is necessary in many other forms and also this new agents will be created from another end too.
Expecting your valuable reply.