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
|
|||
|
|||
Relationships in tables
I have a main table that when you open-you can open other info with the +. I
have the main table with one to one relationship to each table such as: Main table - 2006 info - 2005 info - 2004 info. I added a new table with 2007 info and linked it in the relationship window like: Main table - 2007 info - 2006 info - 2005 info - 2004. However, when I open my main table and hit the + the 2006 table opens not the 2007. Help! |
#2
|
|||
|
|||
Relationships in tables
Sherry
Access is a relational database. The data structure you've described sounds like ... a spreadsheet! In Access, you wouldn't create a table for each year's data (this is embedding data in table names, a no-no). Instead, you'd have ONE table with your data, and add a single additional field to hold "FiscalYear". In fact, depending on what kind of data you are talking about, you might have "TransactionDate" (instead of a whole-year value). In Access, it all starts with the data. We aren't there, so we don't have any idea what data you are working with. If you'll provide a bit more specific description, folks may be able to offer a bit more specific suggestions. And by the way, if you are working directly in the tables rather than via forms, that, too, is very spreadsheetly. Tables store data, but forms display it, in Access. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "Sherry" wrote in message ... I have a main table that when you open-you can open other info with the +. I have the main table with one to one relationship to each table such as: Main table - 2006 info - 2005 info - 2004 info. I added a new table with 2007 info and linked it in the relationship window like: Main table - 2007 info - 2006 info - 2005 info - 2004. However, when I open my main table and hit the + the 2006 table opens not the 2007. Help! |
Thread Tools | |
Display Modes | |
|
|