What you show in your screen shot aren't really tables--though FileMaker calls them that. They are what we call "table occurrences". Whil you can't link to Builders or Builders 2, you can link to a new Tutorial: What are Table Occurrences? that refers to the same data source table as it does.
Enter Manage | Database | relationships, make a new table occurrence of Builders by clicking it and then clicking the duplicate button (2 green plus signs). You can double click the new occurrence box to get a dialog to appear where you can rename the new occurrence box to be SelectedBuilders if you want.
We have not duplicated a table. Instead, this is a new reference to the same table already present in your database.
Add it to your relationships like this:
Service Request::_fkBuilder_id = SelectedBuilder::Builder_id
Then add fields from SelectedBuilders to your Service Request layout to show the name, address, etc of that builder or set up fields in Service Request that use looked up value field options to copy this same data from SelectedBuilder.
Phil, that did it!!!
Thanks again...I should have thought of that, but as you stated, I have to treat them as tables rather than occurances.
Thanks for clearing that up!!!