Quote:
Originally Posted by theducks
This is a relational database. each Author is defined once and assigned a 'index' (that is why it is easy to fix a spelling or case using the tag browser. You fix the definition, not the books that use it.
& is a logical separator in the Authors field and does not exist in the author table, so it can not be a find trigger.
The display is assembled and the & inserted/restored
There are 'n' entries in the underlying books_authors_lnk table for that book . One for each author
|
Oh my god, of course.
Most of my "code" experience is Excel formulas + small bits of VBA. I'm approaching it like a string in a cell. Thank you for pointing this out to me! I need to switch up my mindset here.