AnsweredAssumed Answered

Need help for find request criteria

Question asked by fmdataweb on Mar 7, 2018
Latest reply on Mar 14, 2018 by fmdataweb

I have 2 tables in my FileMaker file as follows:

 

ASSETS

LOAN ASSETS

 

ASSETS contains records for individual Assets that can be loaned to Staff, and the LOAN ASSETS table stores a record for each Asset every time it is loaned out. Here's some sample records:

 

ASSETS

 

Asset IDDescription
W45688Power Drill
W23490Chain Saw
W6654Extension Lead 20m

 

 

LOAN ASSETS

Asset IDDate FromDate To
W4568823/3/201830/3/2018
W2349018/4/201820/4/2018

 

I'm trying to do a find in the ASSETS table to find all Assets that are available for a given date range, so users can see what can be booked for a given date range. I'm completely stumped how to do this and what table I should be searching on or what find requests are needed here.

Outcomes