Thanks opc.three I got if fixed thanks to you.

Lon

Thanks very much ED the example you provided done the trick

lon

Thanks for responding

I am not for sure what your question is . I farly new at this.

Yes I have data in the TRIP_DETAILS TABLE. YES I HAVE DATA IN MY...

COULD SOMEONE PLEASE LOOK AT MY 1st POST. Please tell me if the table structure is a one-to-many.

Thanks

Thanks so very much. It would look like MS would fix this.

I set my dates fields to "date" in sql and my time to "time(4)

I am using vb.net 2010 pro. I am new at this. Maybe i need to do a conversion or somthing in vb. Which I do not know how to do.

thanks

Changing to datetime2 did not work. any other ideas?

thanks

:-PI got it going it was the prmissions.

Thanks so much to all

Ok thanks for educating me on the null thing(good info for me). I do not have any stored procedures in my database or to say I have not created any....

UPDATE TRP_STATS

SET TRIP_ID = TRIP,

FROM TRP_STATS JOIN TRP_DETAILS

ON TRP_STATS.TRP = TRP_DETAILS.TRP;

Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'FROM'.

I get these error about all...

Yes the data came from ACCESS. I imported to sql. Is their anyway I can convert the "UP_DATE" Column to the sql date type. If so could you give me...

I am trying to write a Master/detail code and can't get off to a start on it. I have been working on this this for over a week now. I...

OK I am back. After geting my TRIP_DETAIL table created now I am having problems creating the relationships, and FK's, and by the way I am using sql express 2008....

THANKS FOR YOUR HELP. Got what I needed. You taught me well.

I love this forum

Please Check This query for me.

CREATE TABLE NEW_DETAILS

(

TD_NUM int identity not null,

TRIP int not null,

RIDER_NO int not null,

LNAME nvarchar(20) null,

FNAME nvarchar(20) null,

PROV_CON int null,

APT_TIME time(7) null,

PKUP_TIME time(7) null,

TD_REMARKS nvarchar(20)...