Dukester0122
IS-IT--Management
Hi,
I'm trying to get specific data from table which starts with BS. Example, we manufacture chairs and any component that starts with BS(ITEMCOMP) is always the base of the chair. I need to get this info from the Manufacturing Order table(MO001). Here are the columns that I can use to create the formula:
MFTGORDER - MO0001
FGITEM - CHAIR001
ITEMCOMP - BS001
Thanks.
I'm trying to get specific data from table which starts with BS. Example, we manufacture chairs and any component that starts with BS(ITEMCOMP) is always the base of the chair. I need to get this info from the Manufacturing Order table(MO001). Here are the columns that I can use to create the formula:
MFTGORDER - MO0001
FGITEM - CHAIR001
ITEMCOMP - BS001
Thanks.