Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting data starting with BS

Status
Not open for further replies.

Dukester0122

IS-IT--Management
Mar 18, 2003
587
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top