Beverley has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Auto populate Access Filed
Hello
I am setting up a training database. I have a table for schools, a table for mentors and a table for training events. In the training events table i want to be able to select the name (last & first) of the mentor and for it then to auto poulate the mentor id field ( primary key from mentor table). This is so that you dont have to know the mentor id in order to update the database. Is there anyway to do this?
Many thanks
RE: Auto populate Access Filed
Hi Beverley, thanks for your query. You should be able to achieve this by changing the nature of the mentor id field to a Lookup field. You can do this in Design view. If you use the value from the name field (possibly concatenating the first and last names) and use that as your lookup value, could could then get the lookup field to search for that value in the mentor table and bring back the relevant ID number. Using a Lookup field in this way should be the quickest way to achieve what you want.
Hope this helps,
Anthony
RE: Auto populate Access Filed
Hi, thanks for that.
However as the Mentor ID field is a autonumber it cant also be a lookup field so i am not sure how to make it work.
Thanks
Beverley
RE: Auto populate Access Filed
Hi Beverly. If you can't change the Mentor field, you might need to create a custom field to put the relevant information in. I can't advise you any further without seeing the database, but if you upload it I can have a quick look or you can call our information line for assistance.
Hope this helps,
Anthony
