Ok I am totally new to FM7 I am trying to get a relation ship with to files both have ID numbers , when I create the relationship thats all fine but when I type in the ID number nothing comes up on the related database which have the same feilds as the other one arrrrrrgoing arahhhhhh Does any one have a good web site with screen shots on how this is done or if you can direct me where I can get this info.

Are you tring to create related records in the other table? I don't understand what you are trying to do and what your problem is.

Please update your profile to reflect what Platform, operating system and version of FileMaker you are using.

The link is just below you name in blue "profile"

Lee

Sounds like you are trying to do what I was trying to do recently.

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=121986&page=&fpart=1&vc=1

I stumbled thru it with the help of these forums. If you read the thread where they helped me, you might find the answers you are looking for.

darron

Ok sorry that I woz not clear. I have created 2 databases, FM 1 and FM2 what I am trying to do is that I have FM 1 as the master database that will bring in information from FM2, I have a Primary key for customers. I have created the relation of both databases with the ID number, My problem is that when I add the ID number in the master Database it does not bring in the information from FM2.

Please help!!!!!!!!

Hi nils, you still need to update your profile.

Are you sure that both fields are of the same type (i.e., number to number or text to text) and that you have entered the ID numbers exactly the same?

Jerry