data base table entry against check table

[Former Member]

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

[Former Member]

i update last line of my query

even i tried making changes in foreign key table cardinality as well but its not working.

[Former Member]

Hi sunil,

Multiple entries of forien key are allowed.

Check your primarykey of the table.can you post the screenshot of ur tables

[Former Member]

Hi Sunil,

Multiple entries in Foreign key table should be allowed. Can you give details of the error message?

[Former Member]

thank you all.

i got the solution , i was not maintaining the primary key other than mandt.

regards.