relation between 2 table

[Mike]

Lets say i've 2 table. Order and OrderDetail.

Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.

and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?

Thanks.

Sort your sytem clock out. Moving it ahead 24 hours is likely to result in
people avoiding providing help. All you are doing in effect is "queue
jumping".

 

[Daniel]

Yep i am sick of these people with 'wrong clocks' only way we will get you
guys to learn is to not help until your clock is sorted.

 

[RBarrand]

not the case here, but there's always the chance he's in australia, then his
date (not time) would have been correct
anyhow, take a look at working with data in asp.net 2.0 on the asp.net site

 

[Seth Bourne]

Lets say i've 2 table. Order and OrderDetail.

Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.

and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from his
foreign key (Order.OrderNo) ?

Thanks.

 

[Seth Bourne]

really sorry guys.. there's a problem with my clock...

 

[Seth Bourne]

really sorry guys.. there's a problem with my clock...

 

[Kevin Spencer]

You would never have to worry about your closk if you used SNTP to set the
clock time. SNTP stands for "Simple Network Time Protocol," and it allows
computers on the Internet to synchronize via SNTP servers across the world,
of which there are many. Support for SNTP is built into Windows. See:

http://www.ntp.org/ntpfaq/NTP-s-def.htm

--
HTH,

Kevin Spencer
Microsoft MVP
Bit Player
http://unclechutney.blogspot.com

Expect the unaccepted.