Hi everybody,

I have an company table and it has 2 columns, Company Code and User Code, I

am incrementing "User Code" with "column identity" property of MS SQL Server

2K. I have different companies and those companies have different users. When

I increment User Code one by one, of course it doesnt consider whether it is

the same company or not.

Question 1: How can I satisfy this condition below?

EX:

company user
1---------1
1---------2
2---------3
2---------4
3---------5
4---------6


What I want is

company user
1---------1
1---------2
1---------3
2---------1
2---------2
3---------1
3---------2
3---------3

etc.


Question 2: I want to know that whether it is possible to do that by writing

column formula or not?

You may want to add a third column for that information, so that you can have a column with PK for joining other tables to. Are you asking whether a script can be written to modify the user codes after they're entered, or as they're being entered?

it's ok now, thanx for help