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?