Results 1 to 3 of 3
  1. #1
    DCarrollUSMC is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    1

    Exclamation Help with tables and relationships

    I will try to give as much detail as possible. Please excuse my ignorance, I am a novice Access developer at best. I work for an IT/Networking company and we provide equipment to a local property management company for their apartments. I am creating an access database to handle our inventory. Currently, for this client, I have a table that has the following fields: Building Number (AutoNum), Address (Text), Key (Text), Equipment on-site (text), Equipment Location (Text), etc. I have a form that allows me to manipulate this table (add, delete records, filter by form, etc.). Currently, the field that I am most concerned with is the Equipment on-site field. As it is now, our equipment on site is just stored as text with a list of items contained in each record. I wish to have the equipment on - site field in my form and in my table reference to a separate table. I wish to do this so that I can add detailed records of which gear is in each building and how many of each item are there. Anyone have any ideas for where I should go next? I will be happy to provide any additional information if needed, just please let me know. I hope this will become a fairly detailed post on some forward progress that I should look into to achieve these results.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    This is a basic inventory management application.

    What you need:

    A table that stores all your equipment, and the data related to those items (serial numbers, manufacturer, etc)
    A table that stores all your customers, and the data related to those clients (contact name, phone number, address, etc)
    A table that stores your basic order information and the data related to it (customerID from the customers table, start date, end date, contract number, etc)
    A table that stores your order detail information that's related to the order (itemID from the equipment table, orderID from the orders table, location of equipment on site, building number, etc)

    Make sure all of your tables have a primary key (an autonumber field will work just fine)
    Make sure you don't use special characters (!,#,%,&, etc) or reserved words (date, time, etc.) in your object (query, table, field) names. You'll regret it if you do
    Do not use spaces in any object names either, use the _ (underscore) character if you want to use a space in a field, query, table, etc name
    Think about ways to store as little information as possible and get the desired effect for your database (look for articles about normalization of your data)

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    DCarrollUSMC
    Perhaps I could offer you this link about the Fundamentals of Relational Database Design: http://www.deeptraining.com/litwin/d...aseDesign.aspx
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 1
    Last Post: 10-02-2012, 09:52 AM
  2. Tables Vs Relationships
    By Bruzer in forum Database Design
    Replies: 8
    Last Post: 09-06-2009, 04:39 PM
  3. Help on Tables/relationships?
    By mistaken_myst in forum Database Design
    Replies: 3
    Last Post: 04-01-2009, 05:16 PM
  4. Relationships btw tables
    By metaDM in forum Queries
    Replies: 0
    Last Post: 03-05-2009, 12:15 PM
  5. I need help on relationships for tables.
    By justin.w in forum Access
    Replies: 0
    Last Post: 10-16-2006, 10:57 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