I have three tables with relationships as below (where > is "one to many"):
Manufacturer > Model Group > Model.
I have a table called Asset. The Asset table has a field named Model
On the AssetEntry Form the Model Field is a combo box that gets its values from the Model table but is filtered by unbound combo Model Group which in turn is filtered by unbound combo Manufacturer (cascading combo boxes)
The above structure works fine when first entering a record for the first time.
However, when viewing existing records:
a) Nothing shows in the Manufacturer and Model Group combos (due to the
"selected values" not being stored anywhere.
b) Data in the model field is saved in the underlying table but does not show on the form (as it is filtered by model group which is obviously blank).
My Question:
When viewing an existing record in the Asset form, is it possible to do a reverse lookup using the model value stored in the underlying table (int) to populate the parent combo boxes?
Then if either the Manufacturer or Model Group values are changed (afterupdate), the model value is filtered again.
Any help would be much appreciated.
Ben
Manufacturer > Model Group > Model.
I have a table called Asset. The Asset table has a field named Model
On the AssetEntry Form the Model Field is a combo box that gets its values from the Model table but is filtered by unbound combo Model Group which in turn is filtered by unbound combo Manufacturer (cascading combo boxes)
The above structure works fine when first entering a record for the first time.
However, when viewing existing records:
a) Nothing shows in the Manufacturer and Model Group combos (due to the
"selected values" not being stored anywhere.
b) Data in the model field is saved in the underlying table but does not show on the form (as it is filtered by model group which is obviously blank).
My Question:
When viewing an existing record in the Asset form, is it possible to do a reverse lookup using the model value stored in the underlying table (int) to populate the parent combo boxes?
Then if either the Manufacturer or Model Group values are changed (afterupdate), the model value is filtered again.
Any help would be much appreciated.
Ben
