AnsweredAssumed Answered

Display 1 value from a related table in a layout

Question asked by brianpatterson on Nov 7, 2012
Latest reply on Nov 8, 2012 by Sorbsbuster

Title

Display 1 value from a related table in a layout

Post

     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

Outcomes