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
-
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
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..
Content aside
- 5 yrs agoLast active
- 1Replies
- 1168Views