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
Claude Gosselin