AnsweredAssumed Answered

Pull values from related table based on value.

Question asked by scotty476 on Mar 30, 2012
Latest reply on Mar 31, 2012 by beverly

Hello I am a newbie and need some help.


I am working on a database with stock and prices. Table A is the stock itself and contains symbol, name, last price, and price date. Table B is the actual historical prices and contains symbol (how the relationship is conected), price, and as of date.


I would like to enter a date in table A and have it pull the corresponding price from table B. Ultimatley i will have a check box in table a to either enter a specific date or get the most recent prices.


One small issues is that a lot of these stocks will not be priced regularly and not on a consistant basis.


Any help would be appreciated.