Results 1 to 2 of 2
  1. #1
    raymondbeckham is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    2

    How to prevent duplicates in said example

    Hello, i have a program i am building that consists of three tables,



    1. Customer Info
    2. Computer Info
    3. Jobs

    I have created a form that has all the fields from each table, however as it currently is i am afraid that the database will create duplicate client information, is there a way to easily look up clients if they are already existing and bring in the per tenant data without re-entering it all with only a few clicks? it is all text data that needs to be brought in, address, phone, etc.

    I have a client ID numbering system set up as the primary key.
    last thing is i will be using this program from the form, dont know if that makes a difference.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,506
    You have one form with a RecordSource of three joined tables? This is not the correct way to do data entry into related tables. Review http://office.microsoft.com/en-us/ac...101872705.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Dcount prevent duplicate
    By ayamali in forum Programming
    Replies: 20
    Last Post: 04-16-2013, 09:31 PM
  2. Replies: 3
    Last Post: 02-10-2012, 11:34 AM
  3. prevent diplicate record
    By miziri in forum Access
    Replies: 3
    Last Post: 08-22-2011, 12:34 PM
  4. Prevent Duplicate Entry
    By kilosierra71 in forum Forms
    Replies: 4
    Last Post: 07-28-2011, 03:08 PM
  5. Prevent a form from closing
    By ksmithson in forum Forms
    Replies: 0
    Last Post: 07-15-2010, 12:49 PM

Tags for this Thread

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