I have 2 tables in my FileMaker file as follows:
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:
|W6654||Extension Lead 20m|
|Asset ID||Date From||Date To|
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.