I'm not even quite sure where to ask this question, but here goes:
I am trying to set up a table and a form to track ordering of equipment via Purchase Orders.
I am using the tables for people and agency divisions as linked tables in this database, linked from another database. All the communication between the 2 databases works fine, as at this point I have only 1 form and 1 table for this information. Here's my problem: Both with people and with divisions, the data in the combo boxes, and thus the contents of the fields that is displayed may change: For example, A division may be renamed. This isn't a problem for new entries, but I don't want the Division Name changing on entries that are 2 or 3 (or more) years old. I'm not sure how to track this. For instance, a division called "Budget" may be renamed to "Fiscal Management" in a couple of years. I'd like any old stuff to display the information from what the Division name was when it was originally entered and processed.
Does anyone have any thoughts on how to approach this?
My biggest problem is that I'm trying to make the data entry for the individual who uses this as easy as possible by using a couple of combo boxes. By doing that I've created this little problem for myself.
-- Steve Olson