AnsweredAssumed Answered

Filtering a Related many table in a one to many relationship

Question asked by LWayne_1 on Oct 20, 2011
Latest reply on Oct 24, 2011 by LWayne_1

Title

Filtering a Related many table in a one to many relationship

Post

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.

Outcomes