Our company manufactures auto parts. Each part has a part number, batch number, supplier code, and even a shipping dock code which is a combination of a letter and a number i.e., N1, S2, they are the names of our docks. All numbers assigned to parts are static with the exception of this shipping dock code, it changes for many parts monthly. For example parts that were shipped from N1 dock for one period may be shipped from S2 dock in another period. We call this processes Dock Code Change. It happens every month on 50 to 100 parts. I've been working on a database for a few months that will assist in managing the Dock Code Change process. I receive the Dock Code Change information from an excel spreadsheet where I import into a table in my database.
I'm stuck on a few areas in developing the database but most urgent is the ability to add a value to each new record that is imported. For example, we have 12 periods and I want to add a field to the import table called, "CurrentPeriod". This information is not on the import spreadsheet but I want to add the current period to each new record. The current period is stored in another table but some how I need to stamp each new record with that value. I think the way to do this is through an Update query. Can anyone offer any suggestions? Thanks.