Lookup values vs. using table field
I'm new and working on my first FM12 database. As I understand it, I can lookup a value from a related table if I don't want a value to change when the related table is changed, or I can simply use the fields from the related table in a layout for another table if I want the values to be dynamic. Here is my question: If I use fields from another table to display on a layout, how will the information work upon export? I want the related data to be part of the export, so I'm assuming I need to do a lookup so that data from the related table actually resides in the table I am exporting.