In article <8696564346c90@[EMAIL PROTECTED]
>, "dumeca" <u44653@[EMAIL PROTECTED]
> wrote:
> I am new to Filemaker and am used to using access. I am trying to
create a
> re****t for students information using data from three tables and only
want to
> bring back the records that fit 2 of my criteria (e.g. on;y students
from a
> certain year and class). How do I do that without having to select a
Find
> once I have created a general re****t? Is there anything that would be
> similar to creating an Access query where you can use the raw data from
a
> table, select only certain records and perform calculations on others?
My
> guess is yes otherwise there isn't much point but I am completely
missing the
> way to do it. Any help appreciated!
Others have made useful suggestions.
I add another approach that may be very useful for certain situations:
A specialized relation****p between tables (or a self-join of one table),
based on the criteria for identifying records of interest.
For example, in your situation, you might have a couple of global fields
in one table to hold the year and class of interest, and a relation****p
to the table that holds the assignment of students by year and class.
The relation****p would be:
A::globalYear = B::Year
A::globalClass = B::Class
Where A is the table where you want to use the information and B is the
table that holds registration of students by year and class.
Then in a layout of A you could display and use all the records of B
that satisfy the relation****p.
--
Bill Collins
For email, change "fake" to "earthlink"
|
