Re: Entering data onto a form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



This is the 3rd news group that I have read this same post from you. Please
limit your question to a single thread in a single news group.

--
Duane Hookom
MS Access MVP

"Mellstock" <ireeve138@xxxxxxxxxxx> wrote in message
news:1162664022.535253.240930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.



.



Relevant Pages

  • Re: Entering data onto a form
    ... Column 3 Reference 78 entries Each Partner/Client/Reference is ... Entering a Partner reduces the number of possible Client/References to ... Susequently entering a Client leaves only 1 possible reference ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Entering data onto a form
    ... Column 3 Reference 78 entries Each Partner/Client/Reference is ... Entering a Partner reduces the number of possible Client/References to ... Susequently entering a Client leaves only 1 possible reference ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Entering data onto forms
    ... Already responded to in one of the other newsgroups. ... Microsoft Registered Partner ... reference with each client. ... partner, client and reference. ...
    (microsoft.public.access.reports)
  • Re: Entering data onto forms
    ... comboboxes on your form. ... Microsoft Registered Partner ... reference with each client. ... partner, client and reference. ...
    (microsoft.public.access.externaldata)
  • Re: Searching OO Associations with RDBMS Persistence Models
    ... and the Client needs access to locations for a particular Company. ... In this case I would argue that it should be a reference. ... There are three aspects to relationships: implementation, instantiation, and navigation. ... This sort of instantiation is ubiquitous in OO applications so that one very rarely ever sees a FIND WHERE construct. ...
    (comp.object)