• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

Access autocomplete, autofill data entry based on another table

Hi

I am using access 2010.  I have table called tblPeople with one field [Fullname] .

Example names in this table....  Galen Simpson,   Garnet Doe,  Gail Gaudet

I also have form that is bound to another table  ---   tblSales.

tblSales has been set up to only accept names that are found in tblPeople. In this example,  by the time 3 letters have been entered, Access should be suggesting the rest.

How is this done?
0
peispud
Asked:
peispud
1 Solution
 
peter57rCommented:
You need to use forms for data entry.
On your form you can use a combobox to provide the list of names to select from.

You can build the combobox using the wizard that runs when you add a combo to your form.

Names can and do change, so the normal practice is to store the record ID value from tblPeople in each record in rblSales.
The combo wizard assumes that this is what you want to do.  You can still select from the list using the name and display the name- again the wizard deals with this.
0
 
peispudAuthor Commented:
Thank you for your reply.  I took your advise and assigned a record ID for the person as the reference.  I can see how this approach is very solid.

Have a great day.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now