Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    Table related to multiple tables by single ID


    I am constructing a database which includes three tables containting contact details, loan details and enquiry details. I would like to be able to link the loan and enquiry tables to the contact table via the field contact ID. This would mean that one contact can have multiple loans and multiple enquiries. At the moment my tables will only allow me to display one subsheet so I contacts can have either loans or enquiries but not both. Please can you advise/point me in the right direction??

  2. #2
    jbarrum is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Houston, Tx
    Posts
    164
    If the two tables for loan details and enquiry detials both contain the same fields but are differnt only by their type then I would create a third table [loan type] with two different values and when adding records to the table for [loans] select the appropriate value from they [loan type] table. Combing the data into one table will allow you to create a query allowing you to filter on one type or the other, if needed.

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

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. Replies: 5
    Last Post: 03-23-2011, 10:39 AM
  3. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 AM
  4. Replies: 1
    Last Post: 07-06-2007, 08:27 AM
  5. Replies: 1
    Last Post: 06-21-2007, 01:02 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