Displaying Data from another Dbase

[Jscott]

I have two FM8 files and I want one to pull info. from a field from one and display it in the other.

I could do this in 6 but cannot do it in 8. Why is this? Am I missing something?

[LaRetta]

You must add the other file as a File Reference ( File > Define > File Refererences). Once you have an occurrence of that file in your graph, create a relationship between the two. Then simply place the field from the other file directly on your layout.

Starting in vs. 7, files and tables must be represented in the graph to 1) create a relationship and/or 2) display a field on a layout. It doesn't matter where your data is stored (or whether you have external files) but if referenced in your graph, all the other file's layouts, scripting, etc. can happen all within your main file. The wonders of 7 still amaze me.

L

[Jscott]

Hey.. I have done exactly what you said and I still cannot display data from another file... Can I send the file and maybe you take a look at it to see what is wrong?

[Breezer]

You have several options in the "edit relationship" such as "=", "<", "<", etc, icluding my favorite "X". You may use a match key using a foreign key or if you do not want to use a match key, you can use the cartesian match using the "X" which will show ALL RECORDS instead of the default "=" which will only show records with matching keys.

If this doesn't ring a bell, attach your file and I will show you how.

[Jscott]

Thanks, I sent the file to Filemaker and they resolved the issue..

Thanks again