Hi,
I have two tables the first is user logon table and it has
UserName,Sessionid,logontime,logofftime and LogoffInformation and Request ID.
A session id will be generated for each login and request id will act as primary key , since a user can login more than once.
Second table is Report-Run table which will have the details of the report run by the user on each session.
In one session there can be many reports run.
columns will be Session ID ReportName ,ReportDetail.
Now I have to define cardinality between these two tables and I have doubts on what cardinality it would be .
I know its going to be a left join between Userlogon and Report Run table.
But in FM
is this 1:N to 0:N
or
1:1 to 0:N
which means a session id can have 0 or many reports , I am fine with it.
but what would be the reverse ?
I always get confused in defining the reverse relationship.
Thanks,