0

How do I link a field in 1 table to another table?

A Table named "Customer" has 4 fields, Customer Name, State, City, County. A table named "FLCounties" has 2 fields: County and City. If someone enters the state as Florida and the city is entered as any Florida city, how do I link the fields in FLCounties to the CUstomer table so that the County automatically shows up in the county field of the table named "Customer"?

1 reply

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    Harold, 

    How do you get the Customer information?   Are you typing it in?  Someone else doing it OUTSIDE the Ninox Application and you are importing them?? 

    So.. I imported data from here (it is NOT linked City and County.) 

    http://411.myflorida.com/apps/411/tel411.public_resource.download

    I built a data model like 

    theModel

    Imported into the Z tables.. then moved them over and linked the County to the State of FL .. and manually liked a few cities.. 

    On the customer table.. there is a "Link" button with the following logic.. 

    theCode

    theForm

Login to reply

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 1168Views