I'm trying to use the following to look up records.
I think my problem is the second RELATE - Loc TO Loc.
When I use only the first RELATE - Item_No TO Item_No I get too many records. I need to filter by the second RELATE but can't seem to get the syntax correct, no matter what I try...
SHAPE {SELECT Item_No, Loc FROM ADD_BIN Order by Item_No} AS ParentCMD APPEND ({SELECT item_no, loc, Bin_No,user_def_fld_1,user_def_fld_2,user_def_fld_3, user_def_fld_4 FROM IMINVBIN_SQL Order by Bin_No } AS ChildCMD RELATE Item_No TO Item_No, Loc TO Loc) AS ChildCMD
Thanx in Advance,
Beth
I think my problem is the second RELATE - Loc TO Loc.
When I use only the first RELATE - Item_No TO Item_No I get too many records. I need to filter by the second RELATE but can't seem to get the syntax correct, no matter what I try...
SHAPE {SELECT Item_No, Loc FROM ADD_BIN Order by Item_No} AS ParentCMD APPEND ({SELECT item_no, loc, Bin_No,user_def_fld_1,user_def_fld_2,user_def_fld_3, user_def_fld_4 FROM IMINVBIN_SQL Order by Bin_No } AS ChildCMD RELATE Item_No TO Item_No, Loc TO Loc) AS ChildCMD
Thanx in Advance,
Beth