Hello dear,
can we make multiple entry in foreign key data base table with reference to the same key in check table.
i have tried to make foreign key in foreign key table not as primary key so that i can have multiple entries and selected the
foreign key type as non key-field/candidates as well, but its not working.
i m unable to make to make multiple entry.
status message: data with specified entry already exist in table.
suppose currency is a foreign key and check table is having USD , RS , YEN entries accordingly.
more than one employee can have salary in USD in foreign key data base table.
but it is accepting only one entry.
even i tried making changes in foreign key table carnality as well but it working.
thank you
regards
sunil dhakad
Bluesky
