I have a relationship from one file to another based on two fields. I use the external layout to view the records. From the first file I can "Go to Related Records" and on my mac I either show the records or if there are none I get 0 records. On windows I get the same result if there are related records but if none exist then I still show all the records. I was using this as a way of deleting all the related records at times but now it only works on the mac on the PC I get all the records deleted. Is there a way to go to related records in windows and find out if any are really related or did it just not find any. I am new to v7 and the way I set the relationship works fine for all of the other things I use it for (i.e., portals, etc) and is like I would have done in 5.5. I am also new to Windows so this may be a known problem?

Thanks,

Jim

Another way of checking the validity of related records is to use the IsValid(field) function.

You can specify a field in a related database, and if there is a related record existing it will return a 1 (true) or a 0 (false) if none exist.

Example:

if isvalid(relname::id) = 0

showmessage(No related records exist for this entry.,OK)

else

go to related records(show only related records)

end if

I'd recommend not IsEmpty() instead. See this thread:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB6&Number=135181

Thanks, Thats just what I need.

Jim