I am using a grid for the user to imput information. In the grid I have a combo that is popuplated via an alias(lookup table).

The problem I am having is that when I change the value in the combo it saves the change in the record used to populate the combo not the table that populates the grid.

Ex

GRID

Name Sex DOB
Pete Male 01/01/2004

Table used to populate Grid

Name Sex DOB
Pete 1 01/01/2004

Lookup table

id Type
1 Male
2 Female
3 Other

Therefore when I change the sex to female , I would like the table to contain a 2 under the sex field but show female in the grid. Instead it changes the type Male to Female in the lookup table.

Claude