SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Newbie - Access - Unique Field Values
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

masterkeys
Starting Member

1 Posts

Posted - 10/18/2013 :  07:23:10  Show Profile  Reply with Quote
Hi,

In our project we have a MS Access Database that contains our fileplan of one of our systems, so we can replicate it easily with Excel to an area we need a copy of it on. We don't have access to the IT Servers as the higher powers that be won't let us, so we can't access the backend to copy and paste the structure.

We have 5 lines

Department (Req.), Section(Req.), Class1 (optional), Class2, (Optional), Folder (Optional)


  • Departments, Sections, Classes and Folders must be 100% unique for that department, and not called the same as any department or Section.

  • Departments and Sections are Unique i.e. only one department uses the section name, so are not checked themselves for duplicates, but are used in the duplicate comparison.

  • Folders can have data, when Class1 and/or Class2 are blank



What I'd really like is to add 2 columns to the table:

Item duplicated and Parent Duplicated. In this context item is the last column from Class to Folder that is filled, and Parent is the layers before this.
Folder can appear with any number of the optional classes empty.

What I need is are 2 simple Yes/No box that lists:

[list=a]
  • If Item name has a duplicate

  • If one of the "Parents" has a duplicate, excluding the Department/Section

  • [/list]

    So I can import the one table to Excel. In the future we may be going to a proper SQL DB, so if a solution can work in Access and proper SQL DB without many changes would be great.

    Also we have some old IT Systems we need to replicate this on, so the DB needs to be Access 2003 and Access 2010 compliant.

    If you need any more info please don't hessitate to ask, and thank you in advance for any help

    Masterkeys

    Edited by - masterkeys on 10/18/2013 09:43:22
      Previous Topic Topic Next Topic  
     New Topic  Reply to Topic
     Printer Friendly
    Jump To:
    SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
    This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000