New to Cyrstal... need help with if then else...

[will99]

Hi,

ok my problem is this.

My inventory table has a FIELD (named TYPE) that returns "V" if the item is a KIT ITEM.

I want to put on BOLD the KIT ITEM NAME in the BVE_ORDER_DTL.Ord_Part_no table IF the field on INVENTORY.TYPE = "V". So how do i write the expression to BASED on Inventory.Type to make the KIT item BOLD but also, eventually i want to put ALL the components of the kits in BOLD....

My ultimate goal... is to BOLD all the components that are part of the KIT only.

i hope i was clear enough.

Thank you

William!

[Malvisk]

I think I understand your issue.

1. Right click the Field or the Formula displaying the KIT ITEM NAME.
2. Select Format option from popup menu
3. Click the Font tab
4. Click the X+2 button to the right of the Font Style field

Add the following

IF INVENTORY.TYPE = "V"
THEN crBold
ELSE crRegular