Originally posted by David



hi david,



basically foreign key are used for referencing other table.for that
between any two tables if u want create referencing relation then
necessary condition is that both tables should have one feild common as
u have House_ID

and Person_ID in two tables common and these should be primary key in
any one of the table.



so u have ur two tables as House and Lives there is House_ID which is
composite primary key so setting that feild in any either of both
table as foreign key it will work out.similar is the case with other
two table Person and lives. so i hope this solve ur query if u have
still any doubt

wrie to me.



bye


--
Posted via http://dbforums.com