Answered my fair share of questions in my time mostly in the PowerShell zone, but I am in need of help on something I am not so familiar with! :)
Basically I have some tables in a SQL 2008 Database that are interlinked, consider the attached image which shows how my tables link together.
In the long run though I consider the subscriptions table the parent table. The exch_mailboxes table is the child table and they link together via the exch_domain_services table.
The accounts table has a one to many relationship to the subscriptions table and I included it just so for searching purposes we may be able to search by name instead of subscription ID. The exch_mailboxes_addresses table just lets us pull back email addresses for users.
What I would like to do is have users search for a subscription (accounts may have multiple subscriptions) using the accounts/subscription tables, and then select a subscription, and then be taken into the child elements which will contain the exchange users that belong to that subscription.
I will then worry about letting people make adjustments from that point, but first things first I need to get this working.
I am using ASP.NET C# as my coding language, and I have Visual Studio 2010 which I am somewhat familiar with.
My experience so far has been using Datasets with TableAdapters, SQL stored procs and the GridView controls so those I am familiar with, if it's possible to carry on using those for this it would probably make things easier for me.
I am not afraid to use the codebehind pages for things but less familiar with that than using the GUI for the controls like I have been using.
Any help appreciated!