Hi
I have a doubt About Foreign Key.
There is a table having some feilds including Primary key and now
there is another two tables that also having primary keys.
Here i want to give a foreign key relationship with the two tables to the one column of the main table.
Example
Main table name is "rocket" columns(id (Primary key),rid (Foreign key),name,amount)
remaining tables names "store" ,'department'
'Store' columns(id (P),name,place)
"Department" columns(id (P),name,area)
Here in "rocket" table rid (F) is the foreign key from "store" &"Department" - id's is it possible to give this type as foreign key.