Results 1 to 2 of 2
  1. #1
    marleyuk is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jan 2009
    Posts
    3

    Best way to link tables together?

    Hi,

    I am putting together a database for a debt management project i have for a few clients. I am trying to help them to challange banks regarding different issues. So far i have created 3 tables;
    • tbl_Clients
    • tbl_PPIComplaint
    • tbl_Charges



    One client can have multiple complaints and I want to be able to search for complaints by reference and also locate the complaint through the client details.

    I would like advice on the best way to connect the tables. And also if anyone can surgest good form presentations and a good way to input the information. Ie, Do i have one form for clients with a button to create new claims?

    Please find my current database attached.

    any advice is much appriciated,

    Thanks,
    Marley.

  2. #2
    marleyuk is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jan 2009
    Posts
    3
    No advice?

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

Similar Threads

  1. Link tables on "special" fields
    By Gargen in forum Access
    Replies: 0
    Last Post: 12-18-2008, 12:02 PM
  2. Drop Down, link to another dropdown
    By davelliott in forum Forms
    Replies: 3
    Last Post: 05-23-2006, 08:05 PM
  3. How do link a web form to a access db ?
    By Al in forum Programming
    Replies: 0
    Last Post: 03-16-2006, 06:09 PM
  4. Create the link
    By accessman2 in forum Access
    Replies: 0
    Last Post: 03-13-2006, 01:16 AM
  5. Unable to import or link tables through odbc in Access SP2
    By Dave Jenkins in forum Import/Export Data
    Replies: 3
    Last Post: 11-09-2005, 11:51 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