Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: Matrix situation in MS ACCESS

    Table: Const_brk
    Fields: DbContract pk
    item_no pk
    Title pk
    Quanitity
    in table data is like:

    dbcontract item_no title quantity
    1 89 Roadway 10
    1 89 Bridge 20
    1 89 Ground 30
    1 90 Roadway 10
    1 90 Bridge 20
    1 90 Ground 30


    Note: title varies with every new entry....

    Now user is entering data in this format:

    roadway bridge ground
    89 10 20 30
    90 10 20 30

    i hope i convey you my problem. if i didn't please let me know. I think it is some matrix situation.

    data is in row but i want to capture or display in columns and Data would be updateable and editable.

    Thanks for time and cooperation.

    Waiting for reply.
    mr_roomi

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Why do you have 3 primary keys in the same table? I suggest you re-evaluate your table structure. From what I can see, you should have another table for items.

  3. #3
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Table structure

    This table is child of Off_item table.
    Table: off_item
    DB_CONTRACT PK
    ITEM_NO PK
    DESCPT
    OFF_QUANT
    TYPE_ITEM
    UNITS
    OFF_PRICE

    Thats why i had that primary key in detail table.
    mr_roomi

Posting Permissions

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