Filtering a Related many table in a one to many relationship
I am new to FileMaker Pro but I am familiar with MS SQL. I have two tables StockMaster and Prices with a one to many relationship. On a periodic basis, less say weekly, I would like to calculate the current market value of stocks by multiplying the shares in the StockMaster table against the price on a certain day in the Prices table, the many table. I have tried a global date field in the StockMaster table and set up a relationship using symbol in each table and second using the global date field in the StockMaster table with a PriceDate field in the Prices table. However I receive all records from the Prices table instead of just the records that match the global date field. Can anyone point me in the right direction to return only the records for one days prices?
A filtered portal in my case will not work with what I am trying to accomplish. Thanks for any help.