Help with dual entry selection

R

Radar

Hey guys.
My vendors are causing me problems with dual reorder numbers.
I know I have to change my table to allow duplicate numbers'
How do I get the a box to come up and let the user choose between
items with the same reorder number, and have it entered into my line
items.


Thanks
Radar
 
L

Larry Linson

Radar said:
My vendors are causing me problems with
dual reorder numbers.
Click to expand...

Perhaps a little clarification would be in order. Like what are "dual
reorder numbers" and how are they causing you problems.
I know I have to change my table to
allow duplicate numbers'
Click to expand...

Maybe, maybe not. We surely don't know enough to advise from this
information.
How do I get the a box to come up and let
the user choose between items with the same
reorder number, and have it entered into my line
items.
Click to expand...

First, consider that we don't know what your business or system is like,
don't know if there is good reason for duplicates, don't know how you are
keeping your data, don't know what the record source of the form on which
you want to put the control to let the user choose, and then clarify so
someone might be able to help.

My guess is that you'd use either a Combo Box or a Subform to let the user
choose between items with the same reorder number. But, given the
information here, it'd only be a guess.

Larry Linson
Microsoft Access MVP
 
R

Radar

Pardon me for not being clear.
I have an ordering system where my customers can order assorted adv.
Signs for there stores.
For the most part all of my signs have a unique Reorder or stock # for
restocking their supplies.
There occasions when I receive new signs. They'll have the same
reorder # As other signs in my area. As these signs are cataloged I
can't just change the reorder #.
My intent is to assign a reorder # for my own use, but when Data entry
person enter the reorder #
If the number is also associated with several other signs. I need that
person to see the others signs. And select from that list. Click on
the item they want and have it to enter into the order form.

Thank again
Radar
 
Top