Finding on Relations

[Esmo2000]

I am looking to perform a find on a field in which I want to search on a date range. The relationship I have is a one to many. In the associated database, there are many dates associated with one record. What I had hoped to do was have a find field in the original database which was on the related field, and then zip over to the other database. The reason for needing to perform the search in the first database is a bit complicated so I wont' say here. The problem is that when I perform a find on that related field, I only get results on the first related record to be shown to me. Is there any way that I can get the find to work on all the associated records, or do I have to do it right from the file itself? If I must do it from the file itself, is there any way that I can do it such that it will be transparent to the user? (A script is obviously performed on the transition so I would have that available to me).

Thanks a lot everyone!

Jim

[Ender]

A find on related fields will find those parent records that have one or more child records that match the find criteria. The resulting found set can only consist of the parent records.

If you are really trying to find records from the other table/file, then you should have your script go there to perform the find and show the results.

[Vaughan]

This is probably the trickiest thing with relational databases: tricky from a conceptual point of view only. Technically it's pretty simple and straight forward.

Strick with it, once you understand it you'll see how much easier relational is.