nothing set up at the mo i don't think... let me just jump onto the server and i'll find out

ok here goes nothing.....

CREAT TABLE SCCall

(

Call_Num(PK, int, not null)

Call_Calt_Code(varchar(3), null)

Call_Problem(varchar(50), null)

Call_Site_Num(varchar(12), null)

Call_Site_Post_Code(varchar(10),null)

Call_InDate(datetime, null)

Call_Cust_Num(varchar(12),null)

)

CREATE TABLE SCCust

(

Cust_Num(PK,varchar(12),not null)

Cust_Email(varchar(100),null)

)

INSERT INTO SCCall

(Call_Num, Call_Calt_Code, Call_Problem, Call_Site_Num, Call_Site_Post_Code, Call_InDate, Call_Cust_Num)

SELECT '123456','S24','Replace...

Hi Dugi,

Sorry if i haven't posted the cotrrect info however i am very new at this and im not quite sure i can do what you're saying.

i didn't...