I have four tables that I'm currently using to keep track of employees that have qualified in four different job positions. Is it possible to have a single form that I could use to enter the person's name and qualification date and then via either a combo box or check boxes, have that one form update the desired table?
Or would it actually be better to have a single table that contains the qualification dates of the four positions for each person that is entered? Does it matter?
I might should add that right now the only thing the tables are being used for are to feed combo boxes on another form to annotate who was working what positions. In the future I'd also want to run a query to see when someone was certified for a certain position.