Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing data

Status
Not open for further replies.
Joined
Jul 16, 2004
Messages
153
Hello all,
I have a question. I am a little stumped on how to pull this particular project off. I have two tables, (a)one is a full table, (b) the other is just updates of about 1/2 the fields in the db.

Here are my questions:
1. To create a primary key, I need to use two fields combined. Now should I create anothter field in the DB with both of these fields concatinated or is ther a way to designate column 1 first and column 2 second in checking for a PK? Also if I concatinate them, how do I combine them?

2. For the update, I am going to have to check the PK, then just update the particular records,then add a Date Time Stamp of the update and add a check (U or Y) to another field to say that it was updated by this process. I guess my question is, should I use the wizard for this, or is there something eles I should use?

Thanks
Mel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top