In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
So, if you are enforcing referential integrity you
can not delete data that is referred to by another
table or mess up the basic db structure... (think I
have
tmb wrote:
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
Read up on referential integrity and InnoDB tables in the online docs at
http://www.mysql.com/doc/en
--
Michael T. Babcock
C.T.O., FibreSpeed