Imagine you have a database or a data table that contains information about books, and you have two tables: one for books and another for authors. The "books" table has a field called "Title," and the "authors" table has a field called "Name."
To establish a relationship between the two tables, you create a lookup field in the "books" table that retrieves the names of authors for each book. Since a book can have multiple authors, the lookup field returns a comma-separated array of values (multiple author names) for each book.
For example, let's say you have the following data in the "books" table:
Book ID Title Authors (Lookup Field)
1 Book A John Doe, Jane Smith
2 Book B Michael Johnson, Anne Lee
In this case, the "Authors" field contains multiple values (author names) separated by commas.
Now, when you retrieve the data and display it, the lookup field's order may seem random:
Book ID Title Authors (Lookup Field)
1 Book A John Doe, Jane Smith
2 Book B Michael Johnson, Anne Lee
