|
| 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
December 1st, 2005, 05:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Auto fill of data
I have 2 tables within a database. I wish to compare field 'ID' in
table 'Report' with field 'SchNo' in table Final List, and bring forward the data from field entitled 'Name' in table Report, into a field entitled 'SchName' in table Final List if the 2 id numbers match. How do I go about doing this? 
|
|
#2
December 1st, 2005, 05:08 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Auto fill of data
You should be able to do this with an Update query if you set the
relationship between the field ID and SchNo - I strongly recommend you back your data 1st though!! Sheila " wrote: I have 2 tables within a database. I wish to compare field 'ID' in table 'Report' with field 'SchNo' in table Final List, and bring forward the data from field entitled 'Name' in table Report, into a field entitled 'SchName' in table Final List if the 2 id numbers match. How do I go about doing this?
|
|
#3
December 1st, 2005, 10:18 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Auto fill of data
On 1 Dec 2005 09:01:25 -0800, "
wrote: I have 2 tables within a database. I wish to compare field 'ID' in table 'Report' with field 'SchNo' in table Final List, and bring forward the data from field entitled 'Name' in table Report, into a field entitled 'SchName' in table Final List if the 2 id numbers match. How do I go about doing this? Generally - You don't. Storing data redundantly is NEVER a good idea. Just create a Query joining [Report] to [Final List] by joining ID to SchNo, and base your form or report on this query. It is neither necessary nor good design to store the [Name] in two different places. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| auto fill data into a cell from a lookup table | Tetradpoint | General Discussion | 1 | April 19th, 2005 04:46 PM |
| How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
| names or data not showing up in auto fill sections of document | ketch | General Discussion | 2 | October 6th, 2004 05:15 PM |
| Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Linear Mode
