weird search in relationship, please help

March 13, 200322 yr

hi all,

i came accross a strange situation today, it's been taking me quite some time to try to find out why, i hope someone could help....

i'm having a very basic portal that shows records in another db, i've got a date field as well as some other text fields in this portal. i tried to do a range search on the date field which returned correct results the on first search. problems started to happen when i tried to search for other date ranges (i know that they are all valid searches), FM returned my searches with a list of all the records in the portal and not just the found matched records. i tried this with other text fields which gave the same results, ie, full list... does anyone know what's going on? i checked my relationship and it looked ok, i tried switching the computers and that didnt help...

March 13, 200322 yr

Hi

You can't control what is seen in the portal by doing a simple find in either file. You might want to look at setting up a MultiKey relationship. There was a recent thread that seems to cover what you need.

Do a search for:

Globals Multi-Keys = WOW!!

The post and it's responses cover the MultiKey very good. Look at the response by CobaltSky who also includes a link to his site and a file that is right down your alley.

HTH

Lee

March 13, 200322 yr

The way FM works, searches in your main file will return records in your main file, NOT in the related file. Only the relationship controls what is displayed in the portal, not the result of searches.

Say you have two files A & B with a relationship from A to B. Records in file B are displayed in a portal in file A.

If you are in file A, on a layout showing records from B in a portal and perform a search. What DOESN'T happen is a search for records in file B. What DOES happen is a search for records in file A which have have related records in file B meeting the search criteria.

If you want to find records in file B, you must switch to that file and perform the search. If you want to change what records are displayed in a portal, you must make a change to the relationship which causes this to happen or use another relationship/portal to display the found set.

-bd