I am currently putting together a new Access 2016 Database. I presently have a main form which uses names as the main table. In a subform, I have an appointment form which is comprised of linked tables. In this case the Appt form has a table that includes project, time and date information that is linked to a table that included address and contact information. These forms are connected as a one to many relationship with contacts being the one and appt time/date/project being the many (One contact can be associated with many appts). The main form is connected to the subform with a one to many relationship, the name being the one and the appts being the many.
The Tables and Fields are as follows:
Control Source - Table:
Control Sources - Tables:
(These tables' fields are combined into one subform related the to the main form)
My question is this, I want to be able to type into one of fields in ContactDetailsTable and see if that record already exists and if so associate the entire rocord with the appt record. If not, then I want to add a new record to the ContactDetailsDatabase. What is the best way to do this, can you?
IN other words, is there a way to bring up a combo box in say Company that will search the existing records and populate those fields?