Entering data into 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 / reference. 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.

 

[pietlinden]

in the control on the form, set the default value of the ReferenceID to
a DLookup, maybe...
Just specify the other two fields as criteria for your lookup.