Update Tables in SQL

I am trying to update a key field across my database
The query I am using is

Update TASKEQ
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = TASKEQ.EQNUM)where TASKEQ.EQNUM in (select EQNUM from HullEQ)
Update WOC
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOC.EQNUM)where WOC.EQNUM in (select EQNUM from HullEQ)
Update WOE
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOE.EQNUM)where WOE.EQNUM in (select EQNUM from HullEQ)
Update WOP
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOP.EQNUM)where WOP.EQNUM in (select EQNUM from HullEQ)
Update WOV
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOV.EQNUM)where WOV.EQNUM in (select EQNUM from HullEQ)
Update WOCHVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOCHVW.EQNUM)where WOCHVW.EQNUM in (select EQNUM from HullEQ)
Update WOCVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOCVW.EQNUM)where WOCVW.EQNUM in (select EQNUM from HullEQ)
Update WODESCVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WODESCVW.EQNUM)where WODESCVW.EQNUM in (select EQNUM from HullEQ)
Update WOEHVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEHVW.EQNUM)where WOEHVW.EQNUM in (select EQNUM from HullEQ)
Update WOEQCVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQCVW.EQNUM)where WOEQCVW.EQNUM in (select EQNUM from HullEQ)
Update WOEQLCOM
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLCOM.EQNUM)where WOEQLCOM.EQNUM in (select EQNUM from HullEQ)
Update WOEQLHVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLHVW.EQNUM)where WOEQLHVW.EQNUM in (select EQNUM from HullEQ)
Update WOEQLVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLVW.EQNUM)where WOEQLVW.EQNUM in (select EQNUM from HullEQ)
Update WOEQOVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQOVW.EQNUM)where WOEQOVW.EQNUM in (select EQNUM from HullEQ)
Update WOEVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEVW.EQNUM)where WOEVW.EQNUM in (select EQNUM from HullEQ)
Update WOHISTEQ
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOHISTEQ.EQNUM)where WOHISTEQ.EQNUM in (select EQNUM from HullEQ)
Update WOPHVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOPHVW.EQNUM)where WOPHVW.EQNUM in (select EQNUM from HullEQ)
Update WORHEQVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WORHEQVW.EQNUM)where WORHEQVW.EQNUM in (select EQNUM from HullEQ)
Update WOVHVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOVHVW.EQNUM)where WOVHVW.EQNUM in (select EQNUM from HullEQ)
Update XWOEQVW
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = XWOEQVW.EQNUM)where XWOEQVW.EQNUM in (select EQNUM from HullEQ)
update EQUIP
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = EQUIP.EQNUM)where EQUIP.EQNUM in (select EQNUM from HullEQ)

I imported the HullEQ table from an excel file (the only issue I had is that I had to import as nvarchar it would not let me change it the varchar)

When I execute the query I get
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_TASKEQ_EQNUM". The conflict occurred in database "MP2Live", table "dbo.EQUIP", column 'EQNUM'.
The statement has been terminated.

How do I overcome this?
Gordon
Gordon HughesDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
You would need to COMMIT the new value first so it exists when the foreign key constraint kicks in....

So that would be after taskeq update ( and thankfully you are disciplined to use meaningful names - well done).

Or drop the foreign key constraint from EQUIP and reinstate afterwards....
0
Máté FarkasDatabase Developer and AdministratorCommented:
You have a foreign key in table dbo.EQUIP from column EQNUM to primary key of table MP2Live.
You should add EQNUM keys to that table before you UPDATE tables.
0
Gordon HughesDirectorAuthor Commented:
Hi
Do not know how I would commit the new value or how to drop and reinstall the foreign key
Or what is meant by add EQNUM keys

Please help
Gordon
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gordon HughesDirectorAuthor Commented:
Just as a matter of interest there is a FK_TASK_EQ shown in the TASKEQ table under Keys
Gordon
0
Mark WillsTopic AdvisorCommented:
There will quite possibly be foreign keys on a few of the tables.

Trouble (or challenge) with changing what appears to be KEY fields is that any other dependency will tend to break. And yes, FK_TASK_EQNUM was what the error message raised. So, check EQUIP table. The same way you checked TASKEQ.

You can right click on that KEY name and select modify - but take a copy / save the SQL to disk before you do any changes.

Then read : https://docs.microsoft.com/en-us/sql/relational-databases/tables/disable-foreign-key-constraints-with-insert-and-update-statements  you can disable the ENFORCE and then after the updates, you can go back in and enable ENFORCE again.

Use SSMS to do the work if changing Foreign Key Constraints.

And if a bit unsure, make sure you do a full backup before you begin.

Oh, and to commit the changes, simply type in the word COMMIT; after each update before you move onto the next. Need to start each update with BEGIN TRANSACTION. But disable the ENFORCE is probably better in your case.

It is a huge update - affecting a lot of tables. You really should take a great deal of care and test it all out first. Again, backup before you begin.
0
Gordon HughesDirectorAuthor Commented:
Hi Mark
This all sounds complicated
What is meant by:
You would need to COMMIT the new value first so it exists when the foreign key constraint kicks in....

So that would be after taskeq update ( and thankfully you are disciplined to use meaningful names - well done).

Gordon
0
Gordon HughesDirectorAuthor Commented:
Hi Mark
Not sure if this is OK to do
I went to the  FK_TASK_EQ and went to modify then set the enable Foreign Key Constraint to No
ran the query and then reset it to yes
Does this seem ok to you
I then did the same with the table called Meter

Gordon
0
Mark WillsTopic AdvisorCommented:
In fact, might be very worthwhile checking your DB to find all Foreign Key Constraints affected by your changes...
SELECT 
    C.CONSTRAINT_NAME [constraint_name] 
   ,C.TABLE_NAME [referencing_table_name]                -- table name that has to check another table
   ,KCU.COLUMN_NAME [referencing_column_name]            -- column that will be used to check (must exist) in the other table
   ,C2.TABLE_NAME [referenced_table_name]                -- table being checked for the value to exist
   ,KCU2.COLUMN_NAME [referenced_column_name]            -- column of the above table which must have the existing value
   ,C.TABLE_NAME+'.'+KCU.COLUMN_NAME+' must exist in '+C2.TABLE_NAME+'.'+KCU2.COLUMN_NAME as Conditions
   ,RC.DELETE_RULE delete_referential_action_desc 
   ,RC.UPDATE_RULE update_referential_action_desc

FROM   INFORMATION_SCHEMA.TABLE_CONSTRAINTS C 
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU ON C.CONSTRAINT_SCHEMA = KCU.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME 
INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON C.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME = RC.CONSTRAINT_NAME 
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS C2 ON RC.UNIQUE_CONSTRAINT_SCHEMA = C2.CONSTRAINT_SCHEMA AND RC.UNIQUE_CONSTRAINT_NAME = C2.CONSTRAINT_NAME 
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU2 ON C2.CONSTRAINT_SCHEMA = KCU2.CONSTRAINT_SCHEMA AND C2.CONSTRAINT_NAME = KCU2.CONSTRAINT_NAME AND KCU.ORDINAL_POSITION = KCU2.ORDINAL_POSITION 
WHERE  C.CONSTRAINT_TYPE = 'FOREIGN KEY'
ORDER BY C.CONSTRAINT_NAME

Open in new window

Check all your other tables (in the referencing table) not in the update list, that relies on tables in your update lis (referenced table name) to see where there might be other issues.
0
Mark WillsTopic AdvisorCommented:
The trouble is any table relying on another to have an ID existence, is, what will happen afterwards.

If every detail table ID is currently pointing to a 'parent' table ID, will there be orphaned detail  ID's after all the updates ?

The query above will show those dependencies.

Turning OFF the foreign key is pretty easy, as you have done with FK_TASK_EQ

You would need to do that for all tables having a dependent relationship on another table then after all the updates, set it back again.

So long as EVERY one of the ID's are part of the update, then it should be fine.

I cant tell which are DETAIL and PARENT tables.

Ideally, you have parent tables with update action = cascade and that will also fix up the detail tables. That way, you only "fix" the parent tables and the parent tables will auto-fix the details.

It is a BIG job and he more you dig into it the more you find (and the deeper the hole)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gordon HughesDirectorAuthor Commented:
Hi Mark
Am out at present but will run the query when i get back
Appreciate your help
Gordon
0
Mark WillsTopic AdvisorCommented:
OK, a quick example of what I was trying to say....

We have a product file EE_MW_PRODUCT and one of the Attributes is PRODUCT_COLOR

So, we will need a MASTERFILE named EE_MW_COLORS. Let's create them...
CREATE TABLE EE_MW_Product
(
   Product_ID INT IDENTITY NOT NULL PRIMARY KEY,
   Product_Color_ID int,
   Product_Name varchar(10)
) 

CREATE TABLE EE_MW_Colors
(
   Color_ID int NOT NULL PRIMARY KEY,
   Color_Name varchar(10)
 ) 

 GO

Open in new window

But wait, we do have a dependency. The COLOR must exist, so lets add that dependency (Foreign Key), so let's add that now
ALTER TABLE EE_MW_Product     
ADD CONSTRAINT FK_Product_Color_ID FOREIGN KEY (Product_Color_ID)     
    REFERENCES EE_MW_Colors (Color_ID)     
    ON DELETE SET NULL    
    ON UPDATE CASCADE  

Open in new window

All good so far, so let's start populating - yay :)
-- Now, lets try to insert a product

Insert EE_MW_Product values (1,'New Prod')

-- it fails - and you have seen that type of error message before :
-- The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Product_Color_ID". The conflict occurred in database "testDB", table "dbo.EE_MW_Colors", column 'Color_ID'.

Open in new window

OK, lesson learnt, take a step back and do the MASTERFILE first...
-- So, populate the MASTERFILES first

Insert EE_MW_Colors values (1,'RED')
Insert EE_MW_Colors values (2,'BLUE')

-- And now we can insert some products

Insert EE_MW_Product values (1,'Prod1')
Insert EE_MW_Product values (1,'Prod2')
Insert EE_MW_Product values (2,'Prod3')
Insert EE_MW_Product values (2,'Prod4')

-- let's check the contents

select *
from EE_MW_Product P
inner join EE_MW_Colors C on P.Product_Color_ID = C.Color_ID

/*
Product_ID  Product_Color_ID Product_Name Color_ID    Color_Name
----------- ---------------- ------------ ----------- ----------
2           1                Prod1        1           RED
3           1                Prod2        1           RED
4           2                Prod3        2           BLUE
5           2                Prod4        2           BLUE

(4 rows affected)
*/

Open in new window

But, something is wrong ...  we have an error ... Color 1 RED is wrong. Should be 3 RED  because 1 is GREEN.
-- So let's fix the masterfile

UPDATE EE_MW_Colors SET Color_ID = 3 where Color_Name = 'RED'
 
Insert EE_MW_Colors values (1,'GREEN')

Open in new window

Now lets check our Products again
select *
from EE_MW_Product P
inner join EE_MW_Colors C on P.Product_Color_ID = C.Color_ID
/*
Product_ID  Product_Color_ID Product_Name Color_ID    Color_Name
----------- ---------------- ------------ ----------- ----------
2           3                Prod1        3           RED
3           3                Prod2        3           RED
4           2                Prod3        2           BLUE
5           2                Prod4        2           BLUE

(4 rows affected)
*/

Open in new window

YAY, looks good. And notice how my EE_MW_PRODUCT. Product_Color_ID is now 3
the update of ee-mw-colors has "fixed" the dependent rows as well because of UPDATE CASCADE.
-- And now cleanup
drop table ee_mw_product
drop table ee_mw_colors

Open in new window

Hope that helps the understanding of FOREIGN KEYS....

And that query in my previous post returns the results
constraint_name	referencing_table_name	referencing_column_name	referenced_table_name	referenced_column_name	Conditions	delete_referential_action_desc	update_referential_action_desc
FK_Product_Color_ID	EE_MW_Product	Product_Color_ID	EE_MW_Colors	Color_ID	EE_MW_Product.Product_Color_ID must exist in EE_MW_Colors.Color_ID	SET NULL	CASCADE

Open in new window

0
Gordon HughesDirectorAuthor Commented:
Well Mark
Running the query you sent, i get

FK_ASSET_ASSETNUM      ASSET      ASSETNUM      ASSETNUM      ASSETNUM      ASSET.ASSETNUM must exist in ASSETNUM.ASSETNUM      NO ACTION      NO ACTION
FK_ASSETNUM_TYPE      ASSETNUM      TYPE      ASSETYPE      TYPE      ASSETNUM.TYPE must exist in ASSETYPE.TYPE      NO ACTION      NO ACTION
FK_AUDPURR_PURCHASINGCENTERID      AUDPURR      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      AUDPURR.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_CREDITCARD_1      CREDITCARD      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      CREDITCARD.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_CUSTOBAR_USERID      CUSTOBAR      USERID      MP2USER      USERID      CUSTOBAR.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_DAILYSC_CRAFT      DAILYSC      CRAFT      CRAFTS      CRAFT      DAILYSC.CRAFT must exist in CRAFTS.CRAFT      NO ACTION      NO ACTION
FK_ECACCT_EVENDORKEY      ECACCT      EVENDORKEY      ECVENDOR      EVENDORKEY      ECACCT.EVENDORKEY must exist in ECVENDOR.EVENDORKEY      NO ACTION      NO ACTION
FK_ECACCT_PURCHASINGCENTERID      ECACCT      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ECACCT.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_ECCREDITCARD_1      ECCREDITCARD      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ECCREDITCARD.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_ECCREDITCARD_EVENDORKEY      ECCREDITCARD      EVENDORKEY      ECVENDOR      EVENDORKEY      ECCREDITCARD.EVENDORKEY must exist in ECVENDOR.EVENDORKEY      NO ACTION      NO ACTION
FK_ECPAYMENT_1      ECPAYMENT      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ECPAYMENT.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_ECPAYMENT_EVENDORKEY      ECPAYMENT      EVENDORKEY      ECVENDOR      EVENDORKEY      ECPAYMENT.EVENDORKEY must exist in ECVENDOR.EVENDORKEY      NO ACTION      NO ACTION
FK_ECVENMAP_EVENDORKEY      ECVENMAP      EVENDORKEY      ECVENDOR      EVENDORKEY      ECVENMAP.EVENDORKEY must exist in ECVENDOR.EVENDORKEY      NO ACTION      NO ACTION
FK_EMP_COSTCENTER      EMP      COSTCENTER      COSTCTR      COSTCENTER      EMP.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_EMP_CRAFT      EMP      CRAFT      CRAFTS      CRAFT      EMP.CRAFT must exist in CRAFTS.CRAFT      NO ACTION      NO ACTION
FK_EMP_DEPARTMENT      EMP      DEPARTMENT      DEPT      DEPARTMENT      EMP.DEPARTMENT must exist in DEPT.DEPARTMENT      NO ACTION      NO ACTION
FK_EMPHRS_CRAFT      EMPHRS      CRAFT      CRAFTS      CRAFT      EMPHRS.CRAFT must exist in CRAFTS.CRAFT      NO ACTION      NO ACTION
FK_EMPHRS_EMPCODE      EMPHRS      EMPCODE      EMP      EMPCODE      EMPHRS.EMPCODE must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_EMPWAGE_EMPCODE      EMPWAGE      EMPCODE      EMP      EMPCODE      EMPWAGE.EMPCODE must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_EPAUSAGE_EQNUM      EPAUSAGE      EQNUM      EQUIP      EQNUM      EPAUSAGE.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_EQDRWG_EQNUM      EQDRWG      EQNUM      EQUIP      EQNUM      EQDRWG.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_EQUIP_ASSETNUM      EQUIP      ASSETNUM      ASSETNUM      ASSETNUM      EQUIP.ASSETNUM must exist in ASSETNUM.ASSETNUM      NO ACTION      NO ACTION
FK_EQUIP_COSTCENTER      EQUIP      COSTCENTER      COSTCTR      COSTCENTER      EQUIP.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_EQUIP_DEPT      EQUIP      DEPT      DEPT      DEPARTMENT      EQUIP.DEPT must exist in DEPT.DEPARTMENT      NO ACTION      NO ACTION
FK_EQUIP_EQTYPE      EQUIP      EQTYPE      EQTYPE      EQTYPE      EQUIP.EQTYPE must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_EQUIP_GENLEDGER      EQUIP      GENLEDGER      LEDGER      GENLEDGERNUM      EQUIP.GENLEDGER must exist in LEDGER.GENLEDGERNUM      NO ACTION      NO ACTION
FK_EQUIP_MANUFACTURER      EQUIP      MANUFACTURER      MANUFACT      MANUFACTID      EQUIP.MANUFACTURER must exist in MANUFACT.MANUFACTID      NO ACTION      NO ACTION
FK_EQUIP_PERSONRESPONSIBLE      EQUIP      PERSONRESPONSIBLE      EMP      EMPCODE      EQUIP.PERSONRESPONSIBLE must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_EQUIP_SERVICECODE      EQUIP      SERVICECODE      SERVCONT      SERVICECODE      EQUIP.SERVICECODE must exist in SERVCONT.SERVICECODE      NO ACTION      NO ACTION
FK_EQUIP_SPARECODE      EQUIP      SPARECODE      SPCODE      SPARECODE      EQUIP.SPARECODE must exist in SPCODE.SPARECODE      NO ACTION      NO ACTION
FK_EQXREF_SUBUNIT      EQXREF      SUBUNIT      EQUIP      EQNUM      EQXREF.SUBUNIT must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_EQXREF_UNIT      EQXREF      UNIT      EQUIP      EQNUM      EQXREF.UNIT must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_EVCDT_ID      EVCDT      ID      EQTYPE      EQTYPE      EVCDT.ID must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_EVSDT_ID      EVSDT      ID      EQTYPE      EQTYPE      EVSDT.ID must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_IACRITER_USERID      IACRITER      USERID      MP2USER      USERID      IACRITER.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_INVCOMM_ITEMNUM      INVCOMM      ITEMNUM      INVY      ITEMNUM      INVCOMM.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_INVCOST_ITEMNUM      INVCOST      ITEMNUM      INVY      ITEMNUM      INVCOST.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_INVCOST_WAREHOUSEID      INVCOST      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      INVCOST.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_INVSUB_ITEMNUM      INVSUB      ITEMNUM      INVY      ITEMNUM      INVSUB.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_INVSUB_SUBITEMNUM      INVSUB      SUBITEMNUM      INVY      ITEMNUM      INVSUB.SUBITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_INVVEND_ITEMNUM      INVVEND      ITEMNUM      INVY      ITEMNUM      INVVEND.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_INVVEND_MANUFACTID      INVVEND      MANUFACTID      MANUFACT      MANUFACTID      INVVEND.MANUFACTID must exist in MANUFACT.MANUFACTID      NO ACTION      NO ACTION
FK_INVVEND_UOP      INVVEND      UOP      UOMUOP      UNIT      INVVEND.UOP must exist in UOMUOP.UNIT      NO ACTION      NO ACTION
FK_INVY_ACCTCODE      INVY      ACCTCODE      ACCT      ACCTCODE      INVY.ACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_INVY_COSTCENTER      INVY      COSTCENTER      COSTCTR      COSTCENTER      INVY.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_INVY_EXPENSEACCTCODE      INVY      EXPENSEACCTCODE      ACCT      ACCTCODE      INVY.EXPENSEACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_INVY_OEMMFG      INVY      OEMMFG      MANUFACT      MANUFACTID      INVY.OEMMFG must exist in MANUFACT.MANUFACTID      NO ACTION      NO ACTION
FK_INVY_TYPE      INVY      TYPE      INVTYPE      TYPE      INVY.TYPE must exist in INVTYPE.TYPE      NO ACTION      NO ACTION
FK_INVY_UOM      INVY      UOM      UOMUOP      UNIT      INVY.UOM must exist in UOMUOP.UNIT      NO ACTION      NO ACTION
FK_INVY_WRITEOFFACCTCODE      INVY      WRITEOFFACCTCODE      ACCT      ACCTCODE      INVY.WRITEOFFACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_INVYDRWG_ITEMNUM      INVYDRWG      ITEMNUM      INVY      ITEMNUM      INVYDRWG.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_ISSREC_FROMWAREHOUSEID      ISSREC      FROMWAREHOUSEID      WAREHOUSE      WAREHOUSEID      ISSREC.FROMWAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_ISSREC_PURCHASINGCENTERID      ISSREC      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ISSREC.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_ISSREC_TOWAREHOUSEID      ISSREC      TOWAREHOUSEID      WAREHOUSE      WAREHOUSEID      ISSREC.TOWAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_ISSREC2_FROMWAREHOUSEID      ISSREC2      FROMWAREHOUSEID      WAREHOUSE      WAREHOUSEID      ISSREC2.FROMWAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_ISSREC2_PURCHASINGCENTERID      ISSREC2      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ISSREC2.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_ISSREC2_SERVICECODE      ISSREC2      SERVICECODE      SERVCODE      SERVICECODE      ISSREC2.SERVICECODE must exist in SERVCODE.SERVICECODE      NO ACTION      NO ACTION
FK_ISSREC2_TOWAREHOUSEID      ISSREC2      TOWAREHOUSEID      WAREHOUSE      WAREHOUSEID      ISSREC2.TOWAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_ISSUEP_ITEMNUM      ISSUEP      ITEMNUM      INVY      ITEMNUM      ISSUEP.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_ISSUEP_WAREHOUSEID      ISSUEP      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      ISSUEP.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_LOCATION_COSTCENTER      LOCATION      COSTCENTER      COSTCTR      COSTCENTER      LOCATION.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_LOCATION_DEPARTMENT      LOCATION      DEPARTMENT      DEPT      DEPARTMENT      LOCATION.DEPARTMENT must exist in DEPT.DEPARTMENT      NO ACTION      NO ACTION
FK_LOCATION_GENLEDGERNUM      LOCATION      GENLEDGERNUM      LEDGER      GENLEDGERNUM      LOCATION.GENLEDGERNUM must exist in LEDGER.GENLEDGERNUM      NO ACTION      NO ACTION
FK_MAILUSER_SITEID      MAILUSER      SITEID      SITE      SITEID      MAILUSER.SITEID must exist in SITE.SITEID      NO ACTION      NO ACTION
FK_MANUFACT_TERMS      MANUFACT      TERMS      PAYTERM      TERMS      MANUFACT.TERMS must exist in PAYTERM.TERMS      NO ACTION      NO ACTION
FK_METER_EQNUM      METER      EQNUM      EQUIP      EQNUM      METER.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_METER_UOM      METER      UOM      UOMUOP      UNIT      METER.UOM must exist in UOMUOP.UNIT      NO ACTION      NO ACTION
FK_MOSIA_IN_OVERWRITE_CONTRO_1      MOSIA_IN_OVERWRITE_CONTROL      SOURCESYSTEMID      SOURCEID      SOURCESYSTEMID      MOSIA_IN_OVERWRITE_CONTROL.SOURCESYSTEMID must exist in SOURCEID.SOURCESYSTEMID      NO ACTION      NO ACTION
FK_MP2JOBS_JOB      MP2JOBS      JOB      AVAILJOB      JOB      MP2JOBS.JOB must exist in AVAILJOB.JOB      NO ACTION      NO ACTION
FK_MP2USER_FILTERNAME      MP2USER      FILTERNAME      FILTERMST      FILTERNAME      MP2USER.FILTERNAME must exist in FILTERMST.FILTERNAME      NO ACTION      NO ACTION
FK_MP2USERSETTINGS_USERID      MP2USERSETTINGS      USERID      MP2USER      USERID      MP2USERSETTINGS.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_MTRHIST_EQNUM      MTRHIST      EQNUM      EQUIP      EQNUM      MTRHIST.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_NEXTPO_PURCHASINGCENTERID      NEXTPO      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      NEXTPO.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_NEXTRECR_PURCHASINGCENTERID      NEXTRECR      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      NEXTRECR.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_NPCDT_ID      NPCDT      ID      EQTYPE      EQTYPE      NPCDT.ID must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_NPSDT_ID      NPSDT      ID      EQTYPE      EQTYPE      NPSDT.ID must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_ORDAUDIT_PURCHASINGCENTERID      ORDAUDIT      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      ORDAUDIT.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_PAGERLINKFILTER_1      PAGERLINKFILTER      PAGERLINKNAME      PAGERLINKINFO      PAGERLINKNAME      PAGERLINKFILTER.PAGERLINKNAME must exist in PAGERLINKINFO.PAGERLINKNAME      NO ACTION      NO ACTION
FK_PAGERLINKNEW_PAGERLINKNAME      PAGERLINKNEW      PAGERLINKNAME      PAGERLINKINFO      PAGERLINKNAME      PAGERLINKNEW.PAGERLINKNAME must exist in PAGERLINKINFO.PAGERLINKNAME      NO ACTION      NO ACTION
FK_PAGERMESG_PAGERLINKNAME      PAGERMESG      PAGERLINKNAME      PAGERLINKINFO      PAGERLINKNAME      PAGERMESG.PAGERLINKNAME must exist in PAGERLINKINFO.PAGERLINKNAME      NO ACTION      NO ACTION
FK_POADRS_PURCHASINGCENTERID      POADRS      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      POADRS.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_POFAXEDI_PURCHASINGCENTERID      POFAXEDI      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      POFAXEDI.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_POGENOP_PURCHASINGCENTERID      POGENOP      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      POGENOP.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_POITEMTAX_TAXNAME      POITEMTAX      TAXNAME      TAXRATE      TAXNAME      POITEMTAX.TAXNAME must exist in TAXRATE.TAXNAME      NO ACTION      NO ACTION
FK_PORECVOP_PURCHASINGCENTERID      PORECVOP      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      PORECVOP.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_POSTREC_PURCHASINGCENTERID      POSTREC      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      POSTREC.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_POTAXREV_TAXNAME      POTAXREV      TAXNAME      TAXRATE      TAXNAME      POTAXREV.TAXNAME must exist in TAXRATE.TAXNAME      NO ACTION      NO ACTION
FK_PRODSCHE_EQNUM      PRODSCHE      EQNUM      EQUIP      EQNUM      PRODSCHE.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_PROJECT_PROJECTID      PROJECT      PROJECTID      PROJHEADER      PROJECTID      PROJECT.PROJECTID must exist in PROJHEADER.PROJECTID      NO ACTION      NO ACTION
FK_PROJECT_PROJECTTYPE      PROJECT      PROJECTTYPE      PROJTYPE      PROJECTTYPE      PROJECT.PROJECTTYPE must exist in PROJTYPE.PROJECTTYPE      NO ACTION      NO ACTION
FK_QUOTITEM_INVYTYPE      QUOTITEM      INVYTYPE      INVTYPE      TYPE      QUOTITEM.INVYTYPE must exist in INVTYPE.TYPE      NO ACTION      NO ACTION
FK_QUOTITEM_ORDERWAREHOUSE      QUOTITEM      ORDERWAREHOUSE      WAREHOUSE      WAREHOUSEID      QUOTITEM.ORDERWAREHOUSE must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_QUOTITEM_RECEIVEWAREHOUSE      QUOTITEM      RECEIVEWAREHOUSE      WAREHOUSE      WAREHOUSEID      QUOTITEM.RECEIVEWAREHOUSE must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_QUOTITEM_UOP      QUOTITEM      UOP      UOMUOP      UNIT      QUOTITEM.UOP must exist in UOMUOP.UNIT      NO ACTION      NO ACTION
FK_REQGENOP_DEPT      REQGENOP      DEPT      DEPT      DEPARTMENT      REQGENOP.DEPT must exist in DEPT.DEPARTMENT      NO ACTION      NO ACTION
FK_REQMT_ITEMNUM      REQMT      ITEMNUM      INVY      ITEMNUM      REQMT.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_REQMT_UOM      REQMT      UOM      UOMUOP      UNIT      REQMT.UOM must exist in UOMUOP.UNIT      NO ACTION      NO ACTION
FK_REQMT_WAREHOUSEID      REQMT      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      REQMT.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_RFO_EQTYPE      RFO      EQTYPE      EQTYPE      EQTYPE      RFO.EQTYPE must exist in EQTYPE.EQTYPE      NO ACTION      NO ACTION
FK_SAVESITE_USERID      SAVESITE      USERID      MP2USER      USERID      SAVESITE.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_SITE_PAGERLINKNAME      SITE      PAGERLINKNAME      PAGERLINKINFO      PAGERLINKNAME      SITE.PAGERLINKNAME must exist in PAGERLINKINFO.PAGERLINKNAME      NO ACTION      NO ACTION
FK_SITE_PRIMARYWAREHOUSE      SITE      PRIMARYWAREHOUSE      WAREHOUSE      WAREHOUSEID      SITE.PRIMARYWAREHOUSE must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_SITE_PURCHASINGCENTERID      SITE      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      SITE.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_SPARES_SPARECODE      SPARES      SPARECODE      SPCODE      SPARECODE      SPARES.SPARECODE must exist in SPCODE.SPARECODE      NO ACTION      NO ACTION
FK_SPARES_WAREHOUSEID      SPARES      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      SPARES.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_SPMDESC_EQNUM      SPMDESC      EQNUM      EQUIP      EQNUM      SPMDESC.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_SPMVALS_EQNUM      SPMVALS      EQNUM      EQUIP      EQNUM      SPMVALS.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_STOCK_ITEMNUM      STOCK      ITEMNUM      INVY      ITEMNUM      STOCK.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_STOCK_WAREHOUSEID      STOCK      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      STOCK.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_TASK_ASSIGNEDTO      TASK      ASSIGNEDTO      EMP      EMPCODE      TASK.ASSIGNEDTO must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_TASK_EXPENSECLASS      TASK      EXPENSECLASS      EXPENSE      EXPENSECLASS      TASK.EXPENSECLASS must exist in EXPENSE.EXPENSECLASS      NO ACTION      NO ACTION
FK_TASK_WOTYPE      TASK      WOTYPE      WOTYPE      WOTYPE      TASK.WOTYPE must exist in WOTYPE.WOTYPE      NO ACTION      NO ACTION
FK_TASKEQ_EQNUM      TASKEQ      EQNUM      EQUIP      EQNUM      TASKEQ.EQNUM must exist in EQUIP.EQNUM      NO ACTION      NO ACTION
FK_TAXNAME_TAXCODE      TAXNAME      TAXCODE      TAXCODE      TAXCODE      TAXNAME.TAXCODE must exist in TAXCODE.TAXCODE      NO ACTION      NO ACTION
FK_TAXNAME_TAXNAME      TAXNAME      TAXNAME      TAXRATE      TAXNAME      TAXNAME.TAXNAME must exist in TAXRATE.TAXNAME      NO ACTION      NO ACTION
FK_TIME_ATTENDCODE      TIME      ATTENDCODE      ATTEND      ATTENDCODE      TIME.ATTENDCODE must exist in ATTEND.ATTENDCODE      NO ACTION      NO ACTION
FK_TIME_EMPCODE      TIME      EMPCODE      EMP      EMPCODE      TIME.EMPCODE must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_TIMEKEEP_ATTENDCODE      TIMEKEEP      ATTENDCODE      ATTEND      ATTENDCODE      TIMEKEEP.ATTENDCODE must exist in ATTEND.ATTENDCODE      NO ACTION      NO ACTION
FK_TIMEKEEP_EMPCODE      TIMEKEEP      EMPCODE      EMP      EMPCODE      TIMEKEEP.EMPCODE must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_TSKCRAFT_CRAFT      TSKCRAFT      CRAFT      CRAFTS      CRAFT      TSKCRAFT.CRAFT must exist in CRAFTS.CRAFT      NO ACTION      NO ACTION
FK_TSKINSTR_INSTRCODE      TSKINSTR      INSTRCODE      INSTR      INSTRCODE      TSKINSTR.INSTRCODE must exist in INSTR.INSTRCODE      NO ACTION      NO ACTION
FK_TSKPSHRT_WAREHOUSEID      TSKPSHRT      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      TSKPSHRT.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_USERSITE_ROLENAME      USERSITE      ROLENAME      MP2ROLE      ROLENAME      USERSITE.ROLENAME must exist in MP2ROLE.ROLENAME      NO ACTION      NO ACTION
FK_USERSITE_USERID      USERSITE      USERID      MP2USER      USERID      USERSITE.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_VENDMANU_MANUFACTID      VENDMANU      MANUFACTID      MANUFACT      MANUFACTID      VENDMANU.MANUFACTID must exist in MANUFACT.MANUFACTID      NO ACTION      NO ACTION
FK_VENDOR_MP2CURRENCY      VENDOR      MP2CURRENCY      EXCHRATE      MP2CURRENCY      VENDOR.MP2CURRENCY must exist in EXCHRATE.MP2CURRENCY      NO ACTION      NO ACTION
FK_VENDOR_TAXCODE      VENDOR      TAXCODE      TAXCODE      TAXCODE      VENDOR.TAXCODE must exist in TAXCODE.TAXCODE      NO ACTION      NO ACTION
FK_VENDOR_TERMS      VENDOR      TERMS      PAYTERM      TERMS      VENDOR.TERMS must exist in PAYTERM.TERMS      NO ACTION      NO ACTION
FK_VENDOR_VENDORID      VENDOR      VENDORID      VENDLIST      VENDORID      VENDOR.VENDORID must exist in VENDLIST.VENDORID      NO ACTION      NO ACTION
FK_VENDPO_PURCHASINGCENTERID      VENDPO      PURCHASINGCENTERID      PURCENTER      PURCHASINGCENTERID      VENDPO.PURCHASINGCENTERID must exist in PURCENTER.PURCHASINGCENTERID      NO ACTION      NO ACTION
FK_WACRITER_USERID      WACRITER      USERID      MP2USER      USERID      WACRITER.USERID must exist in MP2USER.USERID      NO ACTION      NO ACTION
FK_WAREHOUSE_ACCTCODE      WAREHOUSE      ACCTCODE      ACCT      ACCTCODE      WAREHOUSE.ACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSE_COSTCENTER      WAREHOUSE      COSTCENTER      COSTCTR      COSTCENTER      WAREHOUSE.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_WAREHOUSE_EXPENSEACCTCODE      WAREHOUSE      EXPENSEACCTCODE      ACCT      ACCTCODE      WAREHOUSE.EXPENSEACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSE_WRITEOFFACCTCODE      WAREHOUSE      WRITEOFFACCTCODE      ACCT      ACCTCODE      WAREHOUSE.WRITEOFFACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_1      WAREHOUSEINFO      EXPENSEACCTCODE      ACCT      ACCTCODE      WAREHOUSEINFO.EXPENSEACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_2      WAREHOUSEINFO      WRITEOFFACCTCODE      ACCT      ACCTCODE      WAREHOUSEINFO.WRITEOFFACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_ACCTCODE      WAREHOUSEINFO      ACCTCODE      ACCT      ACCTCODE      WAREHOUSEINFO.ACCTCODE must exist in ACCT.ACCTCODE      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_COSTCENTER      WAREHOUSEINFO      COSTCENTER      COSTCTR      COSTCENTER      WAREHOUSEINFO.COSTCENTER must exist in COSTCTR.COSTCENTER      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_ITEMNUM      WAREHOUSEINFO      ITEMNUM      INVY      ITEMNUM      WAREHOUSEINFO.ITEMNUM must exist in INVY.ITEMNUM      NO ACTION      NO ACTION
FK_WAREHOUSEINFO_WAREHOUSEID      WAREHOUSEINFO      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      WAREHOUSEINFO.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_WAREHOUSESITE_WAREHOUSEID      WAREHOUSESITE      WAREHOUSEID      WAREHOUSE      WAREHOUSEID      WAREHOUSESITE.WAREHOUSEID must exist in WAREHOUSE.WAREHOUSEID      NO ACTION      NO ACTION
FK_WOGEN_ASSIGNEDBY      WOGEN      ASSIGNEDBY      EMP      EMPCODE      WOGEN.ASSIGNEDBY must exist in EMP.EMPCODE      NO ACTION      NO ACTION
FK_WOMAIL_SITEID      WOMAIL      SITEID      SITE      SITEID      WOMAIL.SITEID must exist in SITE.SITEID      NO ACTION      NO ACTION
FK_WORKWEEK_SITEID      WORKWEEK      SITEID      SITE      SITEID      WORKWEEK.SITEID must exist in SITE.SITEID      NO ACTION      NO ACTION
FK_WORSTAT_SITEID      WORSTAT      SITEID      SITE      SITEID      WORSTAT.SITEID must exist in SITE.SITEID      NO ACTION      NO ACTION
FK_WOSINFO_SITEID      WOSINFO      SITEID      SITE      SITEID      WOSINFO.SITEID must exist in SITE.SITEID      NO ACTION      NO ACTION

The only ones that I needed to disable and rein able were
FK_TASK_EQ and FK_METER

The data looks OK to me
Gordon
0
Mark WillsTopic AdvisorCommented:
OK, then good to go :)

Just check FK_TASKEQ_EQNUM as well.
0
Gordon HughesDirectorAuthor Commented:
Hi Mark
Any suggestions as to how I would check out FK_TASKEQ_EQNUM

GORDON
0
Mark WillsTopic AdvisorCommented:
table taskeq

FK_TASKEQ_EQNUM      TASKEQ      EQNUM      EQUIP      EQNUM      TASKEQ.EQNUM must exist in EQUIP.EQNUM
0
Gordon HughesDirectorAuthor Commented:
Hi Mark

Table TASKEQ
has:-
FK_TASKEQ_EQNUM
TASKNUM
EQNUM
along with loads of other fields
Did a restore on my machine and there is no reference to the TASKEQ table in the EQUIP table

So am sure all is good
Gordon
0
Mark WillsTopic AdvisorCommented:
ok, then all good...
0
Gordon HughesDirectorAuthor Commented:
Excellent Support
Thank you mark for you patience
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.