Skip to main content

Lookup tool isn't finding new record entries to a linked Table

  • November 10, 2023
  • 1 reply
  • 16 views

Forum|alt.badge.img

I've got two tables "Table A" and "Table B", that are linked. Table B utilizes the look up tool to pull certain information from Table A. However new records were added to Table A and the lookup on Table B isn't pulling that information. There's no view, filter or automation conflicting with this so why are newly created records not being found by the look up tool?

1 reply

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • November 11, 2023

Hi,
lookups are based on linking record field. so, new record must contain links in respective field. That should be set up in the process creating new records in a table. Value must be based on a PRIMARY field of Table B.
If  it's not apply to your case, you need to set up automation for that. For example, when record matches condition (some ID is not empty, linked field is empty), update linked field with 'some ID'.