Lookup Data

R

rocket

Hi

I'm a bit new to Access - more used to Dataease DOS!

What I want to be able to do is have users type into a form field called
account ref and then the rest of the account fields i.e. address, contact
no etc to be filled in from the main account table - if that makes sense?

How?
 
R

Rick Brandt

rocket said:
Hi

I'm a bit new to Access - more used to Dataease DOS!

What I want to be able to do is have users type into a form field called
account ref and then the rest of the account fields i.e. address, contact
no etc to be filled in from the main account table - if that makes sense?

It makes sense, but it's a bad idea. All you should be storing in related tables is
the account ref. The rest of the data can be pulled and *displayed* on your other
forms, but you should not copy this data and save it redundantly. Place a small
subform on your existing form with the ref number as the linking field and whenever
you enter a ref number, the relevant information will automatically be displayed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top