I will give that a try the next time I need to migrate.

Thanks,

Phil.

Hi are you looking to copy from Database 1 (has the data) to Datbase 2 (which is blank) but wish to retain the Parent/Child relationships?

If so then from Database 1...

Thanks Jack, I will give it a whirl.

Phil.

Hi once again Jack. Yes the SQL Identity Key is the PK in Parent Table & the FK in the Child Table.

So....Database1

Parent Table

AccountType (PK)

1234

1235

Child Table

TCode (PK)...........Description..........AccountType(FK)

1........................Bibble.................1234

2........................Bobble................1235

So run...

Had a play and all working.

Many Thanks,

Phil.

Thanks for the tips. I shall have a play today.

Regards,

Phil.

Thanks Jack. I will look into the UI side of things. I will run though your code and see how it all works. The user request is not priority, at...

Thanks Steve. It's the narrative I want to return...............one Part / Many Narratives (well that's the plan 🙂 )

Thanks,

Phil.

Hi. Yes. It's required (so I am told) to allow users to tick the line item that has been picked (as opposed putting a red line through the line item!).

Thanks,

Phil.

PS:...

Hi John. Another newbie like me!! It appears that this requirement has gone away so problem solved!! 🙂

Thanks,

Phil.

Thanks for your input John.

Phil.

Mahesh thanks for your time, I managed to resolve (well it looks OK). My query looks as follows:

SELECT DISTINCT ProductId,ProductDescription,ISNULL(CONVERT(VARCHAR,SUM(QuantityOutstanding)),'0')AS Quantity,StandardPrice

FROM Products

LEFT JOIN dbo.Inventory ON dbo.Inventory.Product= dbo.Products.Product

GROUP BY Products.ProductId,...

Gentlemen many thanks for your time and comments. Dan very detailed. How would I convert to traditional ASP? I have noted a long delay as you pointed when I enter...

Hi Steve.

<add name="MyConnectionString" connectionString="Data...

Peso awesome, many thanks to you and to all those that gave their time in assisting me with this problem.

Many Thanks,

Phil.