Forum Discussion

chokedoke's avatar
chokedoke
Regular Visitor
8 years ago

How to report on column with multiple values split by a comma

Hi All,   I currently have a table with multiple columns. Each row has a unique index number, and there is one column that can have a varying amount of entries seperated by a comma. The other probl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

chokedoke,

You can re-create relationship . If you have duplicated values in relationship field in both tables, create another bridge table containing unique values in relationship field, then create relationship among the three tables.

Regards,
Lydia

chokedoke's avatar
chokedoke
Regular Visitor
8 years ago

I have heard these bridge tables mentioned before but im not really familiar with what they are or how they would be set up

 

Could you please point me in the direction of a good example?

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    chokedoke,

    Please help to share sample data of the two tables so that I can provide you detailed steps.

    Regards,

    Lydia