I have a mini contact managment application that many of the users need to upload an import of thier client list froma an excel spreadsheet. Thier spreadsheets do not have thier internal SQL ID. When you add a new item to the add item page it auto defaults the ID field to the correct logged in users ID BUT they you do a bulk import from a spreadsheet it leaves that field blank (As it is not on the spreasheet) and so it will not be visible to the user.
How can I auto default the ID field to the current logged in user while doing the import process so it will personalize for security?
Thanks, Brad