its some labelling program...
just foudna section in the enterprise manager called VIEWS and it could be what im after... but i just saved a view n it didnt appear in my program
here's my view statement:
Code:
CREATE VIEW dbo.Jimtest
AS
SELECT dbo.StyleColourSizeSellingCodes.Item_Code, dbo.StyleColourSizeSellingCodes.ID, dbo.StyleColourSizeProducts.Style,
dbo.StyleColourSizeProducts.Colour, dbo.StyleColourSizeProducts.SizeX
FROM dbo.StyleColourSizeProducts INNER JOIN
dbo.StyleColourSizeSellingCodes ON dbo.StyleColourSizeProducts.ID = dbo.StyleColourSizeSellingCodes.Item_Code
here's the program 9that comes with NO help file