Hi,
I have the following situation:
A field 'Company' that can be filled with two values (from a table ) 'Company_A' and 'Company_B' and field 'Sector' that have to be filled with values of a second table that is filtered with the selection of the field 'Company'. ie 'Company_A => Sector_1 or Sector_2', 'Company_B => Sector_C or Sector_D'.
I associated the field 'Company' and 'Sector' to Lookup Wizards, being the 'Sector' dependent on 'Company'. It works perfect in the Add Page. But when i go to the edit page the field 'Sector' shows always "Select ..", as if it depends on the manual choice of 'Company' to be filtered. But the field 'Sector' already contains a valid value,that is not displayed.
Can you help. I tried the forum but did not found a topic.
Tks,
Almeida
