Display 1 value from a related table in a layout
My database has a table for EVENTS, and a table for VENUES. The primary key in VENUES is a foreign key in EVENTS.
My client needs to display the Venue Name in the EVENT layout. I can save the event name to the EVENTS table using an auto enter calculation, but I think this value would then be stored in EVENTS, and it should really be looked up when needed to keep the database normalized. How can I do this, and am I correct that I should do it?
I've been doing this for years in VB with Access table, but don't see how in FileMaker Pro 12