Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Question Unanswered: Newbie help on db Table Design

    I am having trouble trying to model a database and hope
    that someone can help me here. I'm new at this and still
    learning.

    I have a design that involves what I believe, needs are
    several small tables. One table is the main PROJECT table, an
    ALTERNATIVES table and (x) number of date tables that
    describe different date activities (these are differing
    dates for any given activity). I decided to use several
    smaller tables that involve differing date-related
    activities. I am trying to learn to design tables that do
    not have lots of blank fields and overhead low.

    Sooo...ONE *Project* table with uniquely identified Projects, any Project
    may have MANY Alternatives (1 -> Many Yes?) and each
    Alternative may have an entry in one, some or all of the
    supporting Date activity tables. So, I have inserted a
    foreign key (Proj_ID from tblPROJECTS) into the Alternatives
    table that points back to the Project table. So far, so
    good. I also assume that each date table would want a
    foreign key (Alt_ID from tblALTERNATIVES) from the
    Alternatives table to point back to it also.

    Problem is that when I plugged in some dummy data in the
    tables and setup a query based on all of this, I could not
    change or modify any of the text (Comments, Names, etc.)
    in resulting query. I used the Relationship editor to make sure that these were all set to 1-Many and connected all the like keys to each other in the relevant tables.

    The table setup looks a little like this;

    tblPROJECTS
    Proj_ID (Pri Key)
    Field1
    Field2

    tblALTERNATIVES
    Alt_ID (Pri Key)
    Proj_ID (Foreign Key)
    Field1
    Field2

    tblSSI
    SSI_ID (Pri Key)
    Alt_ID (Foreign Key)
    Field1
    Field2

    tblRAW
    RAW_ID (Pri Key)
    Alt_ID (Foreign Key)
    Field1
    Field2


    Where am i messing up?

    Thanks in advance for those that can teach the less
    informed!

    Pat

  2. #2
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    18
    maybe it helps if u tell us what kind of database u r planning 2 create and /or what type.


    like:

    videotapes/dvd/movie database
    collection database(stamps, butterflies)
    registration database(like toy libraries: eg:

    the members of the toylibrary, the toys the library has in stock, the fees the members have to pay, what toys are available/ lent out reports etc etc)

  3. #3
    Join Date
    Oct 2003
    Posts
    66
    Try changing the Recordset Type property on your query to equal "Dynaset (Inconsistent Update)". This should allow edits to your query's recordset to be reflected in the underlying tables.

    To change this property open your query and right click in the grey area where it lists the tables in the query. Choose "properties" from the popup menu. A Properties box should come up....the Recordset Type should be the 10th property down. If you want more info about the property press F1 when the cursor is in the Recordset Type property box.

    Hope this helps...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •