I have 4 tables linked by a single Employee ID Number.
Table1.EmployeeID
Table2.EmployeeID
Table3.EmployeeID
Table4.EmployeeID
I have a form that I use for data input into Table1. I want to add a simple code after I enter the EmployeeID to automatically append the EmployeeID to table2 table3 and table4. But nothing is working.
I went with a simple DoCMD.RunSQL insert... tried an append just using table2 and a where statement in my sentax for current record, everything. It seems this is super super simple but most the questions on appends are moving massive amounts of data, dozens of fields, and archiving entire tables.
I just want me to put EmployeeID 33342332 and BOOM, 33342332 is added to my other 3 tables. Cannot be that darned hard, right?