I do not want the fields in the table with the foreign key to be able to modify the data in the table with the primary key. How do I prevent this?
I am assuming that you want to show this data from the parent record but not have them be modifiable on that layout. You can do that by:
Enter Layout Mode
Select the ::Field (one at a time or all in a group)
Use the Behavior section of the Inspector's data tab to clear the "Browse Mode" check box and these fields will now not be modifiable on this layout.
Yes that does the trick. Thanks!