AnsweredAssumed Answered

Looked-up Value

Question asked by trevor4370 on Mar 24, 2013
Latest reply on Mar 26, 2013 by trevor4370

Title

Looked-up Value

Post

     I am a noob and am having trouble with Looked-up values (or maybe I should be using something else).

     A simple example as follows:

TABLE 1

     - id

     - Town

     - Postcode

TABLE 2

     - Name

     - Address

     - Phone

     - Town

     - Postcode

     Relationship between ID's

     TABLE 1 has a list of towns and postcodes for each town. When I go to TABLE 2 and select a town from the Dropdown list (Manage Value List - Town in TABLE 2), I would like the Post Code for that town to be automatically displayed. I know this should be simple but I cannot get my head around it - I have spent many hours trying.

     I have tried

     - Creating a relationship between the Towns

     - Town in TABLE 2 - Looked-up Value > Starting with Table = TABLE 2, Lookup from related table = TABLE 1, COPY value from field = Post code.

     - Even tried Lookup on Town.

     Using Filemaker Pro 12 Advanced

      

Outcomes