Totally. thanks Adi and Flo, Thanks all who contributed.

Sorry again for my poor question post. will keep it clearer in future.

Allan.

BINGO!! :w00t:

Chris, you are da man!

This is perfect. 😀

Thank you.

Regards,

Allan.

The order of the PK is not important.

Heres a better example maybe:

DROP TABLE #GroupMembers

CREATE TABLE #GroupMembers (

Group_member_id INT,

Member_name VARCHAR(10),

Group_name VARCHAR(3),

...

Hi, been away so apologies for the delay in getting back to this.

Adi, are on the button with this.

The last bit is, I want to modifty the field called Order,...

Yup :w00t:

Hi,

Order is determined by the customer via the gui.

if the user adds a member to a group using the gui, the default order is the last order +1....

sorry, having a bad day. didnt think it posted first time. delete isnt working for me so cant remove duplicate. :crazy:

Apologies again. I'll be clearer in future.

Based on ChrisM's kind example, which was almost spot on, I've tweaked a few of the order values to demonstrate my problem.

DROP TABLE #GroupMembers

CREATE...

DROP TABLE #GroupMembers

CREATE TABLE #GroupMembers (

Group_member_id INT,

Member_id INT,

Group_id INT,

[Order] INT)

INSERT INTO #GroupMembers (Group_member_id, Member_id, Group_id, [Order])

SELECT...

lol, cant keep up. let me play and I'll get back to you with example.

Hi, please read my second post. The GUI sequence, and the order these members are contacted in, is in the Order field. not the PK fields. Sorry again, should have...

Sorry folks, I should have been clearer. :Whistling:

the sequence is in the Order field. no PK's being touched.

Group_member_id is the unique key, group_id, and member_id are refering to keys in...

The applications should be able to interact with any site and communicate with any other applications on other sites as if they were all being fed from the single location....

Noel,

Thanks for that. I think the location idea might have to be the one, as it would mean the least code changes in the application.

I'm thinking, based on what...

Fantastic article. many thanks.

I have a question.

I have a replicated table with a key field, lets call it 'Id'

Id is an identity field not for replication, which is...