Hello!
I am a beginner and I need your help to get through this problem:
I have a database with the following tables:
tbl employees (contains all personal data about employees)
tbl positions (contains all positions at the company such as operator, shift leader, manager etc)
tbl education topic (contains the title of the education and the positions who have to attend on the education
tbl training courses (contains the title of the education and the participants by name)
I want a form where the "teacher" after each course enters the participants name from a narrowed list. This list comes from the tbl employees and tbl education topic.
Next question: Is there any easy way to create a form where the teacher starts to write in the participant field it automatically offers the right name and the teacher has to push an enter button when the right name appeared: For instance There are two guy Aaron and Arnold. After the first letter has been hit (A) it shows Aaron but if R is hit than Arnold will be active. After hitting the enter button it save the record.
I hope it is clear what I mean
Thank you in advance!