performing finds with related fields

[shannon34]

I have a db set up with a relationship. I have no problem with the relationship but when I try to query the data using any of the related fields I get bogus info. Is there anyway around this?? I want to set up queries and then summarize this info.

Thanks for any help.

Shannon

[RalphL]

Are you doing the finds in the related table? You will get results you weren't expecting if you try to do finds on related data in the parent table. This is very confusing when you do finds in a portal. You get the right results but they are not what you think you asked.

[shannon34]

I am doing finds in the master file using the related fields that I set up for the relationship to the related file. Hope I am making sense. Are you suggesting that a portal might work better?

With my relationship I am pulling information from a database that I want to further query and summarize in my database.

Thanks, Shannon

[RalphL]

No what I am suggesting is to do the find in the related table.

You may be able to do what you want using a special relationship that will find only the records you want in the related table to get the data you are looking for. This would probably require calculated fields in both tables to be the key fields.

I would need a lot more information to more specific.

[shannon34]

Any suggestions you have would be great.

I am working with a fish health database. Groups of fish are given a stock/group name and each individual fish has a pit tag, it's unique identifier. The fish health database has fish from many projects not just ours. I had set up our own database and created a relationship with a match field being the pit tag number. The related fields were then health condition information for that fish.

I then want to be able to search our database and query and summarize information for stocks/groups of fish. When I was performing a find using the stock field, a related field, I would get screwing information. This doesn't happen when this field is not a related field and I just enter the stock along with the pit tag number, but I wanted to avoid entering any data that I could pull from the fish health database.

Shannon-

[RalphL]

This sounds like you have a one to one relationship between your DB and the Fish Health DB. What do you mean by "screwing information"?

[shannon34]

When I search for a group/stock of fish I will get one record repeated several times. When I compare this to my backup file this fish has only one record, not several.

I was playing around today and found that it doesn't matter if I perform the search using related fields or my own that I have created in my database. Once this relationship is set up my find results don't always work?

Right I have a one to one relationship.

First I imported data to my database from the fish health database so I wouldn't have to start from scratch. Then I created a one to one relationship that will pull future information from the fish db for each fish that I enter. Problem is, I need to summarize info. by stock/group and when I try to perform a find after the relationship is set up it is only working for some of the stocks/groups of fish??

Thanks, Shannon

[RalphL]

I have made 2 simple files which I think represent what you have. Fish.fp5 is your file and Fish2.fp5 is the related DB. I have not been able to duplicate your problem. Maybe not enough records.

Take a look at them and let me know if I am on the right track.