Format Database Field From Value Of Another Field

Legacy Poster

• 5. Juni 2014 16:24

Using sql database

Database Name: HAPPY

ICITEMO.OPTFIELD

ICITEMO.VALUE

 

OPTFIELD can either equal INV or INV2ND

VALUE will display the result of each OPTFIELD

 

Goal: To have the value of INV and INV2ND show up on a single label.

 

Every item has a OPTFIELD value for INV. If an item has a value for both INV and INV2 I want the VALUE of both to show up on the label in two different locations. If no value for INV2ND then only show INV value. I think it's VB but a little lost.

Thank you

 

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • 9. Juni 2014 10:00

  From your post, I suppose that ICITEMO is a database table and OPTFIELD & VALUE are database fields on this table. Is this correct?

   

  If so, what do you mean with "an item has a value for both INV and INV2"? Do you mean that two separate database records can have value "INV" and "INV2ND"?

   

  Could you perhaps export the table to a different database engine, such as Access or such as a comma separated text file and attach to this post including the BarTender document as well?

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 22. Juni 2015 12:47

  I have the same issue, I'm hoping this reply can spur some help on the matter. We have a label that pulls ICITEMO.VALUE from the items optional fields(in this case, exception #) but we have to print a entirely different label to pull another optional field (Material #). If I attempt to incorporate both, it will change the first pulled info to whatever the second one is. 

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.