B
Brian P.
Hi there - after spending way too long (i.e 10+ hrs) I'm stuck. I
won't bore you with how many msg boards I've gone though. I'm making
a stock portfolio manager with 4 tables: 1) stock 2) portfolio 3) lot
4) trading activity. Each table has an auto-gen # in column 1 and a
text/date field for column 2.
However, I can't for the life of me sync up the cbo's to trickle down
into the next. I'm trying to have one master form where I 1) select
Google from cboIssuer 2) have cboLot (purchased 6/1/09, 6/3/09,
etc...) auto-populate the next combo box with X number of dates I
purchased the security on 3) choose whatever portfolio I want to trade
in from cboPortfolio (say eTrade or Scott-Trade) 4) have a few text
boxes with quantity, price, fees, etc.. based on tblTrades.
The idea is I choose Google, pick whatever date I initially purchased
it on, allocated it to a certain account, and then put in the
economics of the trade.
I know it seems like a lot, but I can't reverse engineer this bases on
other examples I've downloaded. Any assistance would be greatly
appreciated.
Brian
won't bore you with how many msg boards I've gone though. I'm making
a stock portfolio manager with 4 tables: 1) stock 2) portfolio 3) lot
4) trading activity. Each table has an auto-gen # in column 1 and a
text/date field for column 2.
However, I can't for the life of me sync up the cbo's to trickle down
into the next. I'm trying to have one master form where I 1) select
Google from cboIssuer 2) have cboLot (purchased 6/1/09, 6/3/09,
etc...) auto-populate the next combo box with X number of dates I
purchased the security on 3) choose whatever portfolio I want to trade
in from cboPortfolio (say eTrade or Scott-Trade) 4) have a few text
boxes with quantity, price, fees, etc.. based on tblTrades.
The idea is I choose Google, pick whatever date I initially purchased
it on, allocated it to a certain account, and then put in the
economics of the trade.
I know it seems like a lot, but I can't reverse engineer this bases on
other examples I've downloaded. Any assistance would be greatly
appreciated.
Brian