Entering data onto forms

[Mellstock]

I work with 13 partners for 6 core clients. Each partner has a unique
reference with each client. I have a table with the headings partner /
client / referece. 78 entries in total. When I am preparing an invoice
I need to enter these details onto a form with separate fields for
partner, client and reference.

I can enter the partner (easily from a look up list of 13) and client
(easily from a look up list of 6). Having entered the partner and
client respectively onto the forms there can now only be one reference.


Is there any way of automatically entering the reference having
previously entered the partner and client. At the moment I am faced
with entering it from a look up list of 78!

Anybody with any ideas? Thank you.

 

[Jeff Boyce]

Already responded to in one of the other newsgroups. How is this question
germane to this ("reports") newsgroup?

If you feel you must post to more than one 'group (rarely necessary), please
post a single message once, including the 'groups as the "To:". This way, a
response in one 'group is displayed in all where the question was posted.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/