Hi, im having this problem in a db in access.
I have a form with a subform in it. In this subform i have controls from 2 related tables, one with personal information of people ('people'), and the other relates the first table with a 3rd table('postulacion').
When I enter a person id in the id_postulacion textbox it automatically loads the id in the id_people textbox if that person id already exists in 'people' table (it also loads the rest of that person's info).
What I want to achieve is that even if that id does not exist in 'people' table, it will load the content of id_postulacion in id_people.
Thanks in advance
Santiago
PS: Sorry if my english is not perfect, because im not a native english speaker.