associate one field with another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a form where i need to be able to put in one field and have
access know which corresponding field goes with it.

For example i need to make an invoice where i need to be able to put in
things like "docket Number" and then a field called "Docket Total" (which are
both from a "Docket" table) but i need to set it up so that if i put in
docket number 02356 then in "docket total" the only total listed will be the
one in which corresponds with the docket number...is this at all possible or
am i just asking too much?? i have look up fields on both of these fields as
well if that helps
 
Sarah,

Is this what you're trying to do?

(Q) How do I have a textbox automatically fill in with a value after I
select an item from a combo box on a form (e.g., select a person's ID in a
combo box, and have the person's last name automatically display in a
textbox)?

I print off tips I find on the web I've used in the past and co-incidentally
have my folder open on that page.

This is from the mvp website so I presume I'm allowed to post a link to the
answer. http://www.mvps.org/access/forms/frm0058.htm

I found it helped to print off the sheet and change the fieldnames in the
'how to' for the ones I was using in my database so that I could easily work
through it and didn't get confused.
 
Back
Top