Newbie here...I've been reading these forums for hours and I'm learning so much! I'm a Physician Assistant by trade but necessity has converted me to a pseudo-Access db designer. I have a db that is barely cutting it and I'm designing a new one "done right" so I can use the full potential of Access.
Anyway...I know this is a simple task but I think I can't see the forest through the trees.
I have a demographics form F_Employees with source table M_Employees and it has empSSN, empLastName, empFirstNamet, etc.
I have a separate table for notes M_Notes which I have made a pop-up form to enter a new note. These tables are linked by empSSN and notesSSN. The problem that in order to add a new note I have to enter the SSN on the pop-up form. What I want to do is have the SSN populate on the F_Notes form notesSSN field and insert a new record into the M_Notes table when I click on a control (we can call it ctlAddNote) from the main form F_Employees.
I know this is a simple thing but I'm lost. Please help!