I have a set with 3 DBF tables and 1 Active Link table to a SQL table. The SQL table is storing signature captures from a mobile app. (Im doing this for now because I cant get signature captures to work with dbf tables.)

I have a report on the set pulling data from all 4 tables. Everything works perfectly UNLESS there is only 1 record in the SQL table for the linking key field of the set. As long as their are 2 records in the SQL table that have the same value for the linking field the report will print. If there are only 1 record in sql, the report still prints but the signature capture record from the sql table does not. I confirmed that all 4 tables have the same exact configuration within the set..One to many and linking field. Bizzare!