Results 1 to 5 of 5
  1. #1
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    New Database Design

    Dears

    I am looking to design a data base for our Product Line Test records. The fields would be:

    TestNo
    TestDate
    TestLineNo (Two Lines only)
    Product (As there is 8 types of products but one test can have only one type of product)
    Position01
    Position02
    Position03
    Position04
    Position05
    Position06
    Position07
    Position08
    Position09
    Position10

    Notes: Its a horizontal test line which can accommodate only 8 Pipes if Test line-1 or 10 pipes if test line-2. Each Pipe which is same diameter (named as one type of product) may have same production dates or different product dates. Its important to note that which position pipe was failed/passed (not leaked/leaked) and what was the production date.

    Therefore, how is it possible to enter the Prdn. date of pipe in each position and also after test to highlight that which was leaked or not leaked.



    Later on, a query would be required to design which can help to find the prdn. dates which was leaked or not.

    Kindly advise.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    not sure I understand your question but... so the Position fields could be date fields or if you need both a measurement field and a date field then you need 10 more fields......then as to leaked - that sounds like a checkbox so you need 10 of those assuming 1 per position....

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It looks like you are committing spreadsheet (designing a spreadsheet).

    Consider:

    Code:
    tblTests
    -------------------
    TestID_PK (Autonumber)
    TestNo
    TestDate
    TestLineNo (Two Lines only)
    
    
    tblResults
    ------------------
    ResultsID_PK  (Autonumber)
    TestID_FK (Number - Long) (link to Tests table)
    Product_FK (Number - Long) (link to products table)
    PassFail_FK (Number - Long) (link to PassFail table)
    Position (Number) (Pipe position)
    ProductionDate
    
    
    tblProducts
    ---------------
    Product_PK  (Autonumber)
    ProductDesc (Text)
    
    
    tblPassFail
    ------------
    PassFail_PK (Autonumber)
    PassFailDesc (Text)
    
    (Records would be:
    1 = Pass/No Leak
    2 = Fail/Leaked)

  4. #4
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Hi Mr. Steve

    Thanks for your feedback and i am happy to tell you that i have already done the same except i used value list for Pass/Fail Records.
    I have added three other fields to tblTests which are:

    -Is it Customer Returns? (Yes/No Click)
    - CustomerName -FK (Link to the Customer Table)
    - CustomerProject/Site

    Note: This is what i was looking for and posted an another thread that if i click yes to customer returns then Customername and Customerproject fields must show up otherwise invisible. (at main form)

    tblResults
    ------------------
    ResultsID_PK (Autonumber)
    TestID_FK (Number - Long) (link to Tests table)
    Product_FK (Number - Long) (link to products table)
    PassFail_FK (Number - Long) (link to PassFail table)
    Reason-FK (Link to the reasons table)
    Position (Number) (Pipe position)
    ProductionDate

    Note: In this subform i was looking to disable the field reason until i choose the result is failed.


    Kindly advise the needful.

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

Please reply to this thread with any new information or opinions.

Similar Threads

  1. POS database design help
    By ghardwick in forum Access
    Replies: 1
    Last Post: 02-10-2015, 07:24 PM
  2. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  3. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM
  4. Database design
    By BeetleBailey in forum Database Design
    Replies: 6
    Last Post: 09-20-2011, 01:35 PM
  5. Database Design
    By shutout14cf in forum Database Design
    Replies: 10
    Last Post: 12-20-2010, 11:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums