hi,
It seems like simple, but I can not figure it out.
If anyone know how to do it,pls help me out.
The problem is like following.
I hv two table one for Style and another one for OrderDetail.
Style table look like
Style Color SIZECODE SIZE1 SIZE2 SIZE3 SIZE4 SIZE5 SIZE6 SIZE7
AAA white AB 28 29 30 31 32 33 34
BBB gold W23 23 24 25 26 27 28 29
CCC silver CC 28X30 30X30 32X32 34X32 36X32 32X34 34X34
OrderDetail look like
Style Color SIZECODE QTY1 QTY2 QTY3 QTY4 QTY5 QTY6 QTY7
AAA white AB 10 20 30 50 30 20 10
i would like to do is when the orderDetail forms opens
OrderDetail get a value(size like 24 for qty1) from style table, so i can see the forms look like following
Style Color SIZECODE 28 29 30 31 32 33 34
AAA white AB 10 20 30 50 30 20 10
pls help to complete this job.