OK, I think I partially understand this but could someone clarify this for me.
I have three tables, the first is related to the second and the second is related to the third table.
Table: Work_Loc, Fields: WorkID, WorkName, WorkAddr, etc.
Table: Employee, Fields: EmplID, fk_WorkID, EmplFname, EmplLname, etc.
Table:OrderEntry, Fields:OrderID, fk_EmplID, OrderNo, OrderDesc, etc
On the Order Entry Form I wanted the WorkName of the Employee to show up and I created a Merge Field which contained WorkName. But it will not show the Work Name field. It will show the borders around the box but not the actual text of the work location.
Do I need to include the WorkID in the OrderEntry table to get this to work? If that is so, isn't this going against some principle in relational database theory about being able to store information in one place and pull it out anywhere it is needed?
Or do I need to do something else?
You need to check the values and field types (matching keys should have the same defined data types) to see where this breaks. What you describe should work provided there is a record in the 2nd table with values that correctly link a record in the first table to the current record in the third table as displayed on your layout.
Try just placing this field on your layout as a regular field. Once you can get it to appear, you can change to merge format if you need to. (Unless you need to merge the field value into a block of layout text or text from other fields, you don't actually need a merge field here.)
Yes sir, that is exactly what the problem was. I did not have one field filled out on the Order Form which would allow Filemaker to trace back to the "WorkLoc" table and therefore it didn't show. As soon as I put in the information it popped up.
Sigh! You must hate answering all these "Newbie" questions. But I really do thank you for all your help PhilModJunk.