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
|
|||
|
|||
Access Tables vs Excel Spreadsheets
Can two Access Tables be linked together, much the same as linking cells in
two Excel spreadsheet? What I mean by this question is, in Excel, I can link many cells in a spreadsheet A to one cell in a spreadsheet B. When I update the one cell in spreadsheet B, the many cells in spreadsheet A are linked and automatically up. Can this same linking be done with the cells in two Access Tables? Thank you |
#2
|
|||
|
|||
Hi.
Can two Access Tables be linked together, much the same as linking cells in two Excel spreadsheet? What I mean by this question is, in Excel, I can link many cells in a spreadsheet A to one cell in a spreadsheet B. When I update the one cell in spreadsheet B, the many cells in spreadsheet A are linked and automatically up. Yes, you can . . . but you probably shouldn't. If you intend the "linked cell" in table A to be a re-calculation based upon the updated value in a record in table B, then this value in table A is a value that should be calculated in a query only when needed for display to the customer, not stored in a table. If you intend the "linked cells" to have identical values in the two tables, then this results in duplicate values, which is something that the properly designed relational database avoids. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) - - - When you see correct answers to your question posted in Microsoft's Online Community, please sign in to the Community and mark these posts, so that all may benefit by filtering on "Answered questions" and quickly finding the right answers to similar questions. Remember that the best answers are often given to those who have a history of rewarding the contributors who have taken the time to answer questions correctly. "M KING" wrote: Can two Access Tables be linked together, much the same as linking cells in two Excel spreadsheet? What I mean by this question is, in Excel, I can link many cells in a spreadsheet A to one cell in a spreadsheet B. When I update the one cell in spreadsheet B, the many cells in spreadsheet A are linked and automatically up. Can this same linking be done with the cells in two Access Tables? Thank you |
#3
|
|||
|
|||
I think you may be alluding to a cascading FOREIGN KEY.
See ON UPDATE CASCADE in the help e.g. http://office.microsoft.com/en- us/assistance/HP010322141033.aspx Jamie. -- -----Original Message----- Can two Access Tables be linked together, much the same as linking cells in two Excel spreadsheet? What I mean by this question is, in Excel, I can link many cells in a spreadsheet A to one cell in a spreadsheet B. When I update the one cell in spreadsheet B, the many cells in spreadsheet A are linked and automatically up. Can this same linking be done with the cells in two Access Tables? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 02:15 AM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
How to use a Access Query that as a parameter into Excel database query | Karen Middleton | Running & Setting Up Queries | 1 | December 13th, 2004 07:54 PM |
How to get data from Analysis Services cubes into Access | General Discussion | 2 | December 4th, 2004 02:21 PM | |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |