I am looking for a quick way to enter data.
I have three basic tables
Master employee table: EEID (primary, Autonumber), employee number, name, date of hire
Education table: EDID (primary, autonumber), type of education, date, notes
Education look-up table: TypeID (primary, autonumber), name of education (i.e. CPR or Orientation)
I have a form create for Master Employee Table, in which we can add new employees.
I want to create a combobox with the look-up values from Education Look-up table. After selecting a class (i.e. CPR), hit a button that would open up a datasheet for the Education Table in which I can enter just the employee name and the date of the education. The type of education would automatically populate from the combobox selection.
I have looked everywhere on the net and looked at many examples, but running into trouble in not finding the right code. Any help would be appreciated. I am somewhat of a novice, so any good code examples would be appreciated.
Ron