Results 1 to 3 of 3

Thread: Tables

  1. #1
    Join Date
    May 2012
    Posts
    3

    Unanswered: Tables

    Hi all this is my first post. Just been doing databases for about a month so i'm still pretty useless. I'm trying to set up a database for tracking incoming materials but i'm pretty sure i've made a mess of the tables. Could anyone have a look at the tables below and suggest the correct way to do it and also how to properly set up the relationships.
    The tables 'Tbl_Suppliers' and 'Tbl_RawMaterials' have lists of the various suppliers and materials which are used by 2 combo boxes in Tbl_MainRecords to make a selection

    Tbl_Suppliers Tbl_RawMaterials Tbl_mainRecords
    SupplierID RawMaterialID DeliveryDate
    Supplier RawMaterial RawMaterial
    Supplier
    PartNo
    BatchCode
    Legibility
    Comments



    I tried to upload a picture but am not allowed. Thanks guys

    Emma

  2. #2
    Join Date
    May 2012
    Posts
    3
    Sod it....my tables are all pushed over to the left. The fields are as follows..

    Tbl_Suppliers SupplierID Supplier

    Tbl_RawMaterials RawMaterialID RawMaterial

    TblMainRecords Date RawMaterial Supplier BatchCode Legibility etc

  3. #3
    Join Date
    May 2012
    Posts
    3
    Ok....sorted it out myself

Posting Permissions

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