Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Unique values

Hi Experts!   I have two tables. One with dates and locations; One with dates and performance.  I thought I could create a relationship between the dates, so I can see the Locations and Performance...
  • CahabaData's avatar
    10 years ago

    in addition to J's post - that covers the technical side - - but you probably have a logical dilemma to resolve.  If there are 2 date/locations:

    1/1/16 London

    1/1/16 NY

     

    and 2 date/performances

    1/1/16  Beethovan's Fifth

    1/1/16  Nutcracker

     

    then which goes with which?  unless they always all go together....  in this example I invented you need a 3rd field in both tables, such as 'artist', then you could join on both date and artist fields to create a unique 1:1 relationship.