General Input

[Cind]

I'm new so...I have multiple tables set up each having some simple
information and a # 1, 2, 3, etc. assigned to each piece of data (i.e.
customer abc=1, customer def=2, etc.). When creating a form, I want to have
a field automatically generate itself by grabbing just the # from the answer
the user inputs. So if customer abc is chosen, the first item in the box will
be the number 1 followed by the number of the next table entry it asks for.
In addition, at the end of the all the entries it grabs, I want the last 2
digits of that to be an AUTO number so each final result will be unique. Is
this possible and how?
Thanks in advance.

 

[Jeff Boyce]

I'm having trouble visualizing the table structure you're using ... and it
all starts with the data!

You've described a lot of "how", but I don't really have a sense of "what"
or "why" yet. I ask, not out of morbid curiosity, but because the folks
here may be able to offer alternate approaches if we knew what business need
was being solved.

Regards

Jeff Boyce
Microsoft Office/Access MVP