melbert2002
MIS
- Jul 16, 2004
- 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
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