2 Replies Latest reply on Dec 8, 2008 4:27 PM by raybaudi

    Lookup not working



      Lookup not working


      I have 2 tables: Venues and Bridal Party they are linked via the field IDVenue.


       On the Layout called Bridal Party, I dragged the field – Venues::IDVenue.


       I then set the format to a pop up list that was called Venue List.


       This list was set as follows:


      Use values from first field:                          Also use values from second field:

      Venues:                                                   Venues:

      NameOfVenue                                         IDVenue


      Include all values                                        Sort by first field.


      Then back on the Bridal Party layout  I set the VenueName, VenueAddress, VenueSuburb, VenueState, VenuePostcode to be Lookups as follows:


      Starting with table:                Bridal Party

      Lookup from related table:   Venues


      Copy value from field:          ::NameOfVenue                If not an exact match do not copy.






      Don't copy contents if empty. 


      For each of the feilds. 


      When I try and click the IDVenue field – nothing happens.  What am I doing wrong???