AnsweredAssumed Answered

List only records with prices in a particular field.

Question asked by boltthecolt on Aug 27, 2017
Latest reply on Aug 29, 2017 by beverly

Very basic question.  I have table "books" and a related table "prices".  Prices has US prices, UK prices etc.  Sometimes the field would be empty as the book is not sold into that market.


I wish to create a view that I can also print that shows/outputs the books title, ISBN, etc of only the books that have a price listed in the field I choose. For example the desired result might be show me only the books that are sold into the US and their prices, titles etc.


How do I do this in FileMaker pro?