Since I am setting up all my queries using Stored Procedures, it was easy to implement it using the method above (SCOPE_IDENTITY).

Thanks for all your help.

Thanks a lot for your help.

I'll be setting it up as the majority suggested. I'll create a sing Customer table which the rest of the application will interact with, making...

I don't mind having a single customers table. The only problem is that there is different information for each type.

For instance. If I had all the customers in one table...