Solved: Ref to many - which solution is better? - Page 2

Wojciech_Sz · 04-08-2021 04:25 AM

Hi!
I want to select many items from ref enumlist (and see this entry on ref table)
I want to add new entry for table A, select many workers from Enumlist and see this entry in worker related entries (table B).

I see three options, which is the best?
1/ create columns [worker 1], [worker 2] and ref one per column
2/ many to many reference as - Many-to-Many Relationships
3/ dereference? Use Enum/EnumList (Base Type: REF) to De-Reference Data & Reduce Reverse-Reference Clutter

Steve

Whoops! Try this instead:

FILTER(
  "Protokol serwisowy",
  IN([_THISROW].[e-mail], [Serwisant])
)

View solution in original post