Query on tabular form

hav

Hi all,
I have some queries on tabular form:-
I have created a table "WMProductionBatch" having columns. as SiteNo, BatchNo, Date, Finalised, Processed and Issued.
The Finalised, Processed and Issued columns are of Integer type but they will contain values as either 0 or 1. Note that i have restriction on using the Boolean type for these columns.
I then created a tabular form "Production Batches" whose source table is "WMProductionBatch" . The table box control on the form contains all columns of the table.

Query 1>>>
What i want to do is - instead of displaying three columns Finalised, Processed and Issued each containing either 0 or 1 values, i want to combine three columns into one say "Status" column. However the "Status" should display different coloured check marks whenever there is a value 1 in any of the Finalised, Processed and Issued columns.
i.e:- if a particular row has values as
Finalised | Processed | Issued
----1

---

|

---

0

---

|----1

---

then the Status column should display
<red checkmark> <blank> <green checkmark>
How to achieve this

Query 2>>>
Which trigger gets fired when i double click on a particular row of a tabular form?

Regards,
HAV

DenSter

1: I think you're looking for a method called UPDATEFONTCOLOR. You can look it up yourself by going into the object browser (F5), then in the left column go to CurrForm, the second on Controls, then you select the field you want and you click on the -> arrow on the right lower side of the window. This should display all available runtime control display properties, and color is one of them. I'm doing this without access to navision, so you'll have to search around in there a little.

2: there is no double click event on the form.

ataris

You have an OptionString property on the field which allows you to put options on the field. You could also change the font, colour etc...

You would have to change the datatype to Option..