Re: Rolling Up 3 Separate Tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Regarding developer stuff, I'm several levels below Karl and John, which
might be a plus in this case.

You need to start with table structure.....decide what is the data and
relationships that you are going to database. Sounds like you decided on the
main entities that you are databasing, but not the relationships.
Relationships are something that exist in the real world which you record in
your database. Sounds like the candidartes for the relationships to be
recorded are:

- This office is underneath the following Branch/Organization
- This Department/Organization underneath the following Department/Agency
- This publication is directly a product of the following entity:



While drawing lines between tables etc. (or writing SQL statement) is a part
of linking, the real linking is record to record, and the real work of
linking is done by:

- putting a FK into a table for the purpose of that particular link
- link two records by placing a value that matches one table int the FK
field of another record in the other table.

I'm sure folks would be happy to help with those fundemantal, and knowing
what you are trying to get to would help give that advice, but you'd also
have to clarify some of what you said on the latter including:

- What do mean by "roll up?"
- when you say "I'd like to be able to select from the PUBLICATIONS table, but
want to avoid having to separately select through links OFFICE, BRANCH,
DEPARTMENT." What do you mean? You don't have to go through other tables
to look at your publications table.

Hope that helps a little.








.

Relevant Pages

  • Re: dual combo box
    ... store both values in the respective fields of this record; ... What you say is more "Database Correct", ... >able to access the value of the second column by linking ...
    (microsoft.public.access.forms)
  • Re: Comments on Merge Replication/RDA
    ... > Different publications in same database are not supported. ... > | Though not mention in SQLCE Online Books, ... > | does not support multiple subsribers in handheld. ...
    (microsoft.public.sqlserver.ce)
  • Re: DB Self-destructed!
    ... I wasn't linking to anything. ... Quite some while back I'd imported an old DOS based database in ASCII tab ... I make a backup copy prior to every major ...
    (comp.databases.ms-access)
  • RE: Phantom Publications in Replication DB
    ... Thakns for your response. ... > The best way to delete the phantom is to 'Disable Publishing' on the box. ... > This means you'll need to delete and re-create your valid Publications. ... >> I had one database called RepPublisher and it had 3 transactional ...
    (microsoft.public.sqlserver.replication)
  • RE: Event tracking design question
    ... More to the point, in the book Database Design for Mere Mortals, Hernandez ... states that "The linking table help to keep redundant data to an absolute ... It would have no meaning in any other table. ... Again quoting Hernandez, "When you establish a many-to-many relationship ...
    (microsoft.public.access.tablesdbdesign)