Lookup Data

  • Thread starter Thread starter rocket
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
Back
Top