Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168

    Unanswered: Making two lists into one.

    Is there a way in SQL to create a single list from two different fields.

    I've got one field called [Clients] from one table, and another called[Groups] in another table.

    Is there anyway to get the RecordSource of a combo box to show a list with both these fields as one list.

    E.g.

    [Clients]
    Mr Dave Smith
    Miss Janet Jones

    [Groups]
    Library
    Shop
    Team1

    The resulting list would be:

    Library
    Miss Janet Jones
    Mr Dave Jones
    Shop
    Team1


    Any takers?
    J.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Use a union query

    SELECT tblClients.ClientName FROM tblclients UNION Select GroupName from tblGroups



    gives:

    Library
    Miss Janet Jones
    Mr Dave Smith
    Shop
    Team1



    Gareth
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    Nice one Chief.
    J.

Posting Permissions

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