Skip to main content
Solved

Get value from linked table based on input

  • June 1, 2019
  • 2 replies
  • 42 views
M

I have table with pin code, city and state,
Have second table with contacts
In contact record, if I type pin code then how can I get city and state value filled in related field from linked table, IF function not works for me as pin codes are 26k records.

Best answer by W_Vann_Hall

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.

2 replies

W
Forum|alt.badge.img+5
  • W_Vann_Hall
  • Inspiring
  • Answer
  • June 1, 2019

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.
M
M
  • Manish_Patell
  • Author
  • Participating Frequently
  • June 3, 2019

Thank you very much for your reply, this solved my problem. Much appreciated. :thumbs_up:

Terms & ConditionsAccessibility statement