I want to create a Faculty Database with two tables, one with basic information and the other with teaching history. The two tables should be linked in such a way that when a new record is created in the basic information table, FileMaker will automatically populate the first and last name in the teaching history table. How do I do this? I've tried creating relationships, specifying a look up value... but no luck. Help!!