I played with the upload and it is pretty obvious I need to keep all the data in one table even though some of it is from an Excel upload and some is input. Thanks Jan
--- In [email protected], "Jan" <phssthp...@...> wrote: > > am designing a database for our PMO staffing function. I am thinking > about the master Position/Requisitions table. They get a weekly Excel > extract from another database with changes and new positions. The > primary key will be the client requisition number. > > The PMO staff will add to this 2 more identification numbers when the > information is added to our external recruitment system and our system > for sub-contractors who provide staff. (I don't like it either, but > there it is) > > Should I put all 3 reference numbers in the primary table and deal > with any upload problems or create a second table with the client > requisition number as primary key and then add the other two reference > numbers there? I would rather have only one table but I am worried > about the weekly upload. > > Thanks > Jan >
