*Question No. 01*
there are some kind of foreign key in database
Some of them want give any error when you delete from the table where the
foreign key is in, this cause the remove is "recursive" and it delete also
the ORDER linked to the CUSTOMER (CASCADE foreign key).
In other kind of foreign key
There is a "tool" in Access that can connect an access database to any
type of database [via ODBC].
It can be used as a table, so you can make all query rigth the way as
other table.
i'm sorry but i don't remember the "tool" name.
Hope this will help.
2007/4/23, Steve Smith <[EMAIL PROTECTED]>: