Prev: SAS Connect issue.
Next: SUB character and blank rows on CSV import
From: Craig Johnson on 8 Feb 2010 16:47
I=92m using a layered approached to data entry and have an instance where I
need an the ID in a single file act as a PK in one instance and a FK in
another. Here is the way it works=85.



1) IDList stores all possible IDs: ID is a PK

2) Data is entered into =93file one=94 where ID is a FK (If the ID isn=
=92t in
the IDlist it can=92t be entered)

3) Data is entered into =93file two=94 and is compared against =93file=
one=94
(verification process) . If the ID is in =93file one=94 it can be in =93fi=
le
two.=94 If the ID is not in =93file one=94 then it should not be in =93fil=
e
two.=94(You can't verify what hasn't been entered). SO,
in this circumstance I need the ID in =93file one=94 to be a PK while the I=
D in
=93file two=94 needs to be a FK.



The question is, is there a way for the ID in =93file one=94 to be a FK for=
step
2 but a PK in step 3 without constantly dropping and reinstating IC's?
 | 
Pages: 1
Prev: SAS Connect issue.
Next: SUB character and blank rows on CSV import