topic data base table entry against check table in Application Development and Automation Discussions

data base table entry against check table

Former Member — Sun, 24 Aug 2014 04:10:43 GMT

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 — Sun, 24 Aug 2014 04:14:00 GMT

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 — Sun, 24 Aug 2014 04:35:14 GMT

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 — Sun, 24 Aug 2014 04:54:40 GMT

Hi Sunil,

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

Former Member — Mon, 25 Aug 2014 05:31:46 GMT

thank you all.

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

regards.