A
Atrus2711
Hi,
I'm using a form which is bound to an disconnected ADODB recordset. The
control source of my form are set to the fields names of this recordset. This
works great and enables my form to receive data input from my user without
saving these data to the database.
My user selects an article number, and this implies that the package unit
and the currency (= two of my article fields) are implicitly selected as
well. Currency and package unit of my articles are defined as foreign key in
other tables/recordsets. So, selecting article #47 sets currency #1 (EUR) and
package unit #23 (yard).
Now, trouble strikes: No user wants to see these forreign key values of
currency #1 and package unit #23. Instead, the "meanings" of these values
(EUR / yard) are requested. I've developed business classes for currency and
package unit to provide these "lookup values", and on startup of my
application, an object oCurrencies and oPackageUnits are created. The "live"
during the whole app runtime. I thought this would be a fast and simple way
to "translate" key values in their meanings.
But i was wrong. I've found no way so far to bind my textfield "currency" to
the properties oCurrencies.Clearname or oPackageUnits.Clearname.
Controls *do* allow the binding to *some* properties: Me.Name shows the name
of the form, and Me.Width works as well. How can i use my own objects in
this way?
Thx for any hint!
Regards
I'm using a form which is bound to an disconnected ADODB recordset. The
control source of my form are set to the fields names of this recordset. This
works great and enables my form to receive data input from my user without
saving these data to the database.
My user selects an article number, and this implies that the package unit
and the currency (= two of my article fields) are implicitly selected as
well. Currency and package unit of my articles are defined as foreign key in
other tables/recordsets. So, selecting article #47 sets currency #1 (EUR) and
package unit #23 (yard).
Now, trouble strikes: No user wants to see these forreign key values of
currency #1 and package unit #23. Instead, the "meanings" of these values
(EUR / yard) are requested. I've developed business classes for currency and
package unit to provide these "lookup values", and on startup of my
application, an object oCurrencies and oPackageUnits are created. The "live"
during the whole app runtime. I thought this would be a fast and simple way
to "translate" key values in their meanings.
But i was wrong. I've found no way so far to bind my textfield "currency" to
the properties oCurrencies.Clearname or oPackageUnits.Clearname.
Controls *do* allow the binding to *some* properties: Me.Name shows the name
of the form, and Me.Width works as well. How can i use my own objects in
this way?
Thx for any hint!
Regards