form cbo box 2 columns saved to two fields?

[Brook]

hello all,

I have a combo box that I use for my order entries, the combo box is
based on the values that I have entered:

Column 1 > Order Type > I want to save this to field ordertype in my
tblorders
Column 2 > Order Abbreviation > I want to tsave this to field orderabbr
in my tblorders

any suggestions?

Thanks,

Brook

 

[John Vinson]

hello all,

I have a combo box that I use for my order entries, the combo box is
based on the values that I have entered:

Column 1 > Order Type > I want to save this to field ordertype in my
tblorders
Column 2 > Order Abbreviation > I want to tsave this to field orderabbr
in my tblorders

any suggestions?

One suggestion is...

Don't.

If orderabbr can always be deduced given the knowledge of ordertype,
then storing it in tblorders would be redundant and - not merely
unnecessary - but bad design, since once it's stored then either
ordertype or orderabbr could be changes, making it invalid. Ordinarily
you'ld just look up orderabbr by a Query joining to OrderTypes.

If you have some good reason to do this, post back.

John W. Vinson[MVP]