Skip to main content
Question

Multievent log : Can 3 tables which dont have any foreign key be combined into multievent log functionality ?

  • March 31, 2023
  • 2 replies
  • 7 views
.
Level 6

I have 3 tables in excel format

  1. Table 1 contains P2P activity data
  2. Table 2 contains inventory movement activity data
  3. Table 3 contains activity data for production order.

 

Unfortunately they dont have common key , but each table dont have foreign key to link each other, can still event logs be merged using automerged functionality and represent on process explorer ?

2 replies

G
Level 12

I doubt it, although never tested this. Maybe if there is an indirect relationship via other table (and of course, havins a 1:N relationship between the activity tables)

dany.moual11
Level 5
Forum|alt.badge.img+7

I agree with @Guillermo Gost, since it should be possible to filter the table with each other.

 

If you can connect the case tables in a certain way, for instance the MARC table is involved in all the three processess, then you can make the Multi-eventlog functionnality. There is actually no need of a comon foreign key, but rather a direct or indirect relationships between case tables.

 

I hope it helps,

Dany

Community Code of ConductAccessibility statement