AnsweredAssumed Answered

Create Report using 2 Tables

Question asked by LarryMadden on Feb 28, 2011
Latest reply on Mar 1, 2011 by philmodjunk

Title

Create Report using 2 Tables

Post

I am new to Filemaker Pro and I am trying to create a report using 2 tables.

I am trying to build a mini warehouse database.  I am trying to create a report based on 2 tables (contract & ware#).  The contract table draws info from several tables including Ware#.  It is the main table in which information is collect to create a contract between the renter and the owner.

I am wanting create a report that shows all vacant warehouses.

In the contract table, I am using the following fields:

Contract Date, Client Name, Warehouse #, Termination Date (There are other fields but I thought these were the only ones necessary, really don't even need Client Name).

What I was thinking was:

1) If Warehouse # has an associated contract date and no termination date, then the warehouse # is not vacant.

2) If Warehouse # is not in a contract, then it is vacant.

3) If Warehouse # has an associated contract date and does have a termination date, the unit is vacant.

I suppose a query needs to be run on the contract table to find all Warehouse #'s that have a Contract Date and no Termination Date and then compare to the Ware# table that includes all units to find the vacant units.

I don't know how to do this.

Any help would be appreciated.

Outcomes