I guess that depends on how your project number is derived.

Is it a calculated field that combines the fk field (SchoolID) and
data from other fields?

Is it a multi-field PK?

--
_________

Sean Bailey


"golfinray" wrote:

I can't change project numbers, beetle. Wouldn't that change my project
number are I am off base there?
--
Milton Purdy
ACCESS
State of Arkansas


"Beetle" wrote:

Don't you have a foreign key in the table of construction
projects relating back to the table of schools? Can't you just
update the FK field?

Update tblProjects Set SchoolID = 3205 Where SchoolID = 3501;
--
_________

Sean Bailey


"golfinray" wrote:

We have had school districts consolidate so now Altheimer and Dollarway
School Districts are now joined and are just Dollarway School District. Our
ID number for Altheimer was 3501. Our ID for Dollarway is 3205. So Altheimer
construction projects were labeled 0607-3501-001, 0911-3501-016, etc.
Dollarway projects are numbered 0607-3205-012 or 0708-3205-008. So now, when
I pull up Dollarway School District on my construction tracker form or
construction approval forms, I need Altheimer's projects to appear also. We
don't want to change project numbers. Project numbers are my PK. Help please!
Thanks!!
--
Milton Purdy
ACCESS
State of Arkansas