I have 2 separate database files that I need to share field data. One has basic demographic information and the second has more specific information. I have made a script which automatically opens the second file as follows: Open (second file)
Go to related record (show only related records) from table (first file) using current layout (2nd file) There are a few text and number fields (no calculations) which I would like to carry over onto the 2nd file. I have tried inserting the fields from the first file directly into the second file layout and tried setting relationships without consistent success. This should be an easy task which I have done in the past. What am I missing??