AnsweredAssumed Answered

Lookup not working

Question asked by milky on Dec 8, 2008
Latest reply on Dec 8, 2008 by raybaudi

Title

Lookup not working

Post

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.

                                           ::AddressOfVenue

                                           ::SuburbVenue

                                           ::StateVenue

                                           ::PostcodeVenue

 

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???

 

Milky

 

 

 

 

Outcomes