Relationships in tables

[Sherry]

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!

 

[Jeff Boyce]

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