Hi,

I have two tables:

Table 1 “Unknown”

Table 2 “Known”

These tables are not joined, due to the fact that their data is not really related.

However they both have a “Date Entered” and “Entered By” fields.

Is there a way to join these two tables so that I can do a single search for a date range and entered by without having to do it for each table, as I do now.

Thanks,

Jim

You can have an interface where there are two portals (one for each table) that displays the results for each one.

For example, lets say you use a third table that is a oen record preferences table (or session table). You can have your global fields in it for your date start, date end, and entered by name.

Then your portals can be "filtered" to dispaly the information taht you want for both portals.

The other approach is to use two differnt windows for each found set for each table. There are no UNIONS in FileMaker.