Skip to Content
0

How to join check and foreign key relation table in Help View ?

Jan 05, 2017 at 06:43 AM

22

avatar image

Hello,

In Help View, I have two tables employee and project.

employee table(check table) contains fields mandt, empid, empname where empid is primary key

and project table(foreign key) contains mandt, empid, projid, projname where empid is the foreign key.

I can establish relationship between project table and employee table which are foreign key and check table respectively.

But in the reverse situation i.e. when i am trying to establish a relation between employee table and project table facing an issue with unsuitable cardinality.

Can you please suggest me solution where i can able to establish a relation in employee and project table.

uacva.png (21.0 kB)
k5d2p.png (20.0 kB)
kas6l.png (13.2 kB)
o7vf2.png (18.7 kB)
rmbio.png (6.5 kB)
dajox.png (16.5 kB)
fdfzk.png (27.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers