Access Help

[Klaus L Jensen]

Is there a GOOD page on the net where I can get help to ACCESS and not TSQL,
access is not TSQL

I have this script...

ALTER TABLE [Ordre] ADD CONSTRAINT KunderOrdre FOREIGN KEY ([Kunde id])
REFERENCES [Kunder] ([Kunde id])

problem is: in table kunde there is a row (kunde id) there do'not exists in
ordre table....

is there a way to check for do WITH NOCHECK...???

I get a syntax error!!

Please help!!!!

Med venlig hilsen
Klaus Ladegaard Jensen

 

[Roger Carlson]

Let me see if I can rephrase your question correctly.

You have two tables that you want to create a relationship between and the
related table (Kunder) has a record that does not exist in the main table
(Ordre). You are wondering if there is a way in Access SQL to create this
relationship and ignore the orphaned record. Is that correct?

If so, I believe the answer is no. As far as I know there is no way to
force Access to create a relationship if it will result in orphaned records.
You will have to clean up the tables manually (or programmatically).

There is not much help out there for Access SQL DDL (data definition
language). It is just so much easier to use the GUI that it isn't discussed
much. The best resource I have found is "Access Database Design and
Programming" by Steve Roman and published by O'Reilly.

Hope that helps.