I am tracking incidents for saftey, and want to pull the personal information for accidents from the HR database. I currently have linked tables, but when HR fires an employee, they remove their information from that database, while I need to maintain it for my records. I have a table in my own database that I want to populate one time with an update query, but currently, my Form based Command Button will try to update ALL records.
How do I set up the 'query to select one record' or the 'command button to select one record'