Skip to main content
Question

Table relationships using phone number

  • April 10, 2020
  • 0 replies
  • 26 views

Forum|alt.badge.img+5

I want to build a relationship between two tables using a phone number field, but a phone number field can't be used as a key field.  If I convert the phone number to a text or numeric field using a formula, formula fields can't be used as a key field.  Is there a word-around to this so that I can set up a relationship for the tables using the phone number as the linkage?

The best I've been able to come up with is a report link field that displays a link from Table 2 to Table 1.

Table 1 contains customer accounts with a Key Field is Customer ID.  This key field can't change because record updates are imported from another system.

Table 2 contains phone call records with the standard Record ID# as the key field.



------------------------------
Jim Lieder
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
Can you store the phone number in text format and use that as the Key field?    If the data entry is by hand, you have a form rule populate the text field based on a formula โ€‹field off the phone numbered entered.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------