I have 2 DBs and a relationship to link them by an ID number.

DB1 contains only live jobs, for example 10 records in there.

DB2 contains all jobs, for example 80 records in there.

In DB2, how do I find those 10 records contained in DB1?

Thanks

Why not just keep all the job records in one table, and have a field called "live" that is either true or false? Then you can just search that field.

In your example, you would just place a related field from your "live jobs" table in your "all jobs" layout. Go to find mode in the "all jobs" table and search for records which have a corresponding related record in the other table.

I edited the question. not sure why it was posted twice.

I understand the logic - Go to find mode in the "all jobs" table and search for records which have a corresponding related record in the other table.

But not sure what exactly how to do so? Can you give me more direction?

Thanks

Unfortunately, I don't have a copy of FM6 anymore, so I can't post an example that you can open unless you have FM7 or 8...

On a layout in your "all jobs" file. Just insert a field from the related file (referenced from the relationship you defined based on the key field) onto the layout. Any records that have related records in the other table will have a value in that field (provided there is a value in the field in the other record... so choose one that is never empty, like the key field)

When you enter find mode, place the zero or more characters wildcard into that related field (*), and do the find.

Maybe someone with filemaker 6 can make an example.

I do have FM7.

Your suggestion woudln't work. Because there is value in the related field in all records. Some records are old so they don't exist in the "live job" table. I can't search by non-empty value of that related field.

Thanks