+ Reply to Thread
Results 1 to 2 of 2

Newbie - Relationships

  1. #1
    Ken
    Guest

    Newbie - Relationships

    Could someone please help me.

    I have constructed a Database with several Tables that contain Names and
    Addresses.
    The Database consists of several Tables each containing 65000 records.

    What I wish to do is to set up a query so that when I search for a surname
    the output will
    list all the matching surnames in all the Tables.

    I think I need to set up the relationships between the tables but although I
    have tried the trial
    and error method I cannot get it to work.

    Any help appreciated

    Please reply to group or to ken@nospamgorseport.fsworld.co.uk (remove
    nospam)

    Many thanks in advance

    Regards

    Ken



  2. #2
    Ken
    Guest

    Re: Newbie - Relationships

    Apologies - picked wrong news group - will get myself off to the MS Access
    newsgroup


    "Ken" <ken@nospam.fsworld.co.uk> wrote in message
    news:cr9snb$me3$1@news7.svr.pol.co.uk...
    > Could someone please help me.
    >
    > I have constructed a Database with several Tables that contain Names and
    > Addresses.
    > The Database consists of several Tables each containing 65000 records.
    >
    > What I wish to do is to set up a query so that when I search for a surname
    > the output will
    > list all the matching surnames in all the Tables.
    >
    > I think I need to set up the relationships between the tables but although
    > I have tried the trial
    > and error method I cannot get it to work.
    >
    > Any help appreciated
    >
    > Please reply to group or to ken@nospamgorseport.fsworld.co.uk (remove
    > nospam)
    >
    > Many thanks in advance
    >
    > Regards
    >
    > Ken
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1