Prefilling Data in Table

[Joyce]

I'm new to Access and just learning so this may be a very
basic question. In my table I have a field for location,
phone and fax number. I have 15 locations. I want a
specific phone number to prefill in the telephone and fax
fields based on the location entered, is there an easy was
to do this.

I appriciate your help, thank you

 

[Howard Brody]

You shouldn't store the phone/fax numbers in two different tables. It's redundant and can lead to bad data (if you don't update all the appropriate records everytime something changes)

Instead, create a location table (tblLocations), with fields for LocID, LocDesc, LocPhone, LocFax and any other data you want to track for each specific location.

Then, in your main table, simply store the LocID and create a Relationship between the two tables on the LocID field.

This way, you can always pull the phone and fax numbers with a query or a lookup on a form

Hope this helps

Howard Brod


----- Joyce wrote: ----

I'm new to Access and just learning so this may be a very
basic question. In my table I have a field for location,
phone and fax number. I have 15 locations. I want a
specific phone number to prefill in the telephone and fax
fields based on the location entered, is there an easy was
to do this

I appriciate your help, thank yo