Results 1 to 2 of 2
  1. #1
    handsome1855 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    2

    how to link 3 tables?

    How to join following 3 tables

    1.Distrcts
    District ID Autonumber
    District Name Text
    Contact Person Text

    2.Books
    Book Number Number
    District Name Text (from Table 1)
    Issue Date Date & Time

    3. Book Pages
    Tickets Numbers Autonumber (1 to 50)
    Fine Imposed Number



    Best Regards,
    khurram

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    There is insufficient info to give you a meaningful answer.
    What is your business? How do these things fit in your business?

    There are data models here that may help you put things into context.
    http://www.databaseanswers.org/data_models/index.htm

    As for database design there are several helpful sites.
    http://www.rogersaccesslibrary.com/forum/topic238.html

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

Similar Threads

  1. Link Tables Not Refreshing
    By goodguy in forum Import/Export Data
    Replies: 14
    Last Post: 01-04-2011, 12:49 PM
  2. One-way link between tables
    By Mikele di Sagitter in forum Database Design
    Replies: 1
    Last Post: 07-23-2010, 08:26 AM
  3. How do I link existing tables?
    By jsbdiver in forum Programming
    Replies: 0
    Last Post: 05-24-2010, 02:53 PM
  4. Join three or more tables in many to many link
    By elicoten in forum Database Design
    Replies: 3
    Last Post: 02-04-2010, 06:51 PM
  5. Best way to link tables together?
    By marleyuk in forum Access
    Replies: 1
    Last Post: 06-07-2009, 08:44 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