Finding records

[ctls]

Hi,

Its me again! I am quite new to filemaker pro and I am not sure what its capable of and what it isnt!

Anyway, question is:

I have two tables.

one with People ID, names and address and

two with People ID and status.

The two tables are related through ID. I want to Find records in Table one(i.e. ID, name and address) with a condition on status(say status = employee) from the Table two.

Is it possible to "Constraint Find"? Is it possible to search records from one table using a condition on a field from a related table?

I'd be thankful to anybody who'd help me out here.

Thanks.

Prithvi

[bruceR]

Yes, you can do that, and I wonder why you don't just try it and find out what happens.

But there is a complication. The fact that you have a separate table for status suggests a one to many relationship. One person can have many status records. May you have a date in status, who knows. But at any rate, if you really do have a one to many relationship, then performing the find you are asking for will find anybody who has at least one "employee" record even though perhaps he also has a "manager" status record.