Mulitple updates to a table based on the changing # of records from an import tbl

[databasedave]

I am attempting to create a function that when called will look at a table (table 1) that is imported daily. I need to take those records and insert them into a permanent table (table 2). After this occurs I need to update that table 2 with numbers that are held in a seperate table (table 3) and once assigned (from table 3) are marked as having been assigned (so that they are not assigned again). The number of records that are being imported (table 1) will vary. My question is how can I go about assigning these numbers to table 2 after the records have been inserted from table 1? What code do I need to include in my function to carry this out? Thank you in advance for any help you can give.

 

[Ian Mac]

What assisgns the numbers, whats the criteria??

Can you expand a little on what you actually want to achieve.
Also, you may want to lonk at the idea of Linking the Table (Table 1) if you are not going to be using it after your function.

 

[databasedave]

Assigning predetermined number and marking they 'assigned'

What I am trying to do is assign a reserved set of numbers to a particular record that has been imported into my table table that stores a collection of these imported files. The number I am assigning has to be recorded to the record as it comes in and cannot be assigned again. If this were only one record I could do it with a simple update but since it may be one or several hundres I need to know what I would need to do (probably in a function) to assign the numbers properly and mark the table that holds these number as having been assigned.

Thank you for your time....