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.