Results 1 to 4 of 4
  1. #1
    esqfathy is offline Novice
    Windows 10 Access 2013
    Join Date
    Feb 2016
    Posts
    2

    Creating many fields in one field

    Hello everyone

    I am a lawyer working in a company and i need to develop a database to store the cases in. I created the table (attached) which contains all the fields i need. However, there is a certain field that i can not do, which is about the adjournments of the cases' hearings.

    Now lets say that for each single case (record) i have these fields: Case no., company name. opponent name, strategy, notes, next hearing & decision, the problem is at the last two fields:

    lets imagine scenario:

    the first hearing of the case is on:



    01/01/2016: first hearing then adjourned until:

    05/01/2016: to serve the summons to the defendant: ...

    10/01/2016: for the defendant to prepare statement of defense

    and so on

    The most recent date should be always in the future, and on the top.

    So how can i create multiple (anything) in one field?

    I will appreciate if someone can do it on the attached database with some explanation.

    One more thing, I want to create a form based on the table to see how it will look like.

    Additional ideas will be appreciated.

    Thanks in advance

    Regards

    Muhammad
    Attached Files Attached Files

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    So how can i create multiple (anything) in one field?
    you can't. tried to open your attachment but it wouldn't let me - says the file is invalid.

    One table suggests that you are not using the db as intended. If you require multiple anything, it is held in a separate table with a link back to the main table - it's parent.

    If you are using it like excel - what would you do there? answer, copy the row and change one or more columns. result, data redundancy in that many columns hold the same data

    with a db, the 'objective' is to hold data once and refer to it as and when required

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Muhammad,

    I suggest you review this design guide by Barry Williams.
    The key to database is to get your tables and relationships designed to support your business.
    So, start with a clear description of your business and business rules.
    Good luck.

  4. #4
    esqfathy is offline Novice
    Windows 10 Access 2013
    Join Date
    Feb 2016
    Posts
    2
    Many thanks

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

Similar Threads

  1. creating new fields from form
    By mike02 in forum Forms
    Replies: 1
    Last Post: 05-18-2013, 09:23 AM
  2. Creating a report using the same fields
    By clawschieff in forum Reports
    Replies: 3
    Last Post: 04-17-2013, 12:48 PM
  3. Creating Dummy Fields in a Report
    By Whehir in forum Reports
    Replies: 2
    Last Post: 06-13-2012, 05:45 PM
  4. Creating a unique index on two fields
    By Paul H in forum Database Design
    Replies: 3
    Last Post: 11-03-2011, 10:15 AM
  5. Creating Custom Fields
    By RudeRam in forum Queries
    Replies: 3
    Last Post: 08-01-2011, 01:09 PM

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