form cbo box 2 columns saved to two fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook - 11 Apr 2005 04:09 GMT

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

Reply to this Message

John Vinson - 11 Apr 2005 06:35 GMT

>hello all,
>
[quoted text clipped - 7 lines]
>
> 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]

Reply to this Message