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
IF Venues and Bridal Parties are linked through a Field
in Venues:IDVenue
and in Bridal Party:IDVenue
Why would you drag Venues:IDVenue to Bridal Party?
It is the other side of the link between Venues and Bridal Party.