If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatic filling of fields in table two from table one
Table one contains fields with information on stocks. Example, field one is
StockSymbol, field two is StockName, field three is Exchange, etc. Overall there are about 30 fields per record in Table one. Table two contains portfolios for clients. Field one of Table two has ClientID, fields two and three are identically named to Table one's fields one and two. These clients own various stocks (all of which are in Table One) but many clients in Table two do not own the same stocks as other clients do. I only want to reflect pertinent field info for clients holding stocks contained in Table one. I want to know if there is a way to link field information from Table one to Table two so that as I add new clients' portfolios to Table two I can just enter StockSymbol in field two of Table two and the StockName, etc. fields in Table two will automatically populate with appropriate data from the same-named fields in Table one for the stock record matching the StockSymbol I have entered? Since the StockSymbol is unique for each stock record in Table one, using the StockSymbol field name in Table two should trigger a relationship between the two tables that would allow for automatic filling-in of same-named fields in Table two based upon identical content being entered in Table two, StockSymbol field. I am new to ACCESS so please be as clear as possible in your answer. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ComboBox fields to Update record in a table | LMB | New Users | 6 | September 20th, 2004 09:27 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Image Control Table | John Gavin | General Discussion | 3 | June 28th, 2004 04:21 AM |
Cannot join 1:M table into M:M tables | Tom | Database Design | 4 | May 19th, 2004 10:16 PM |