Help

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

Topic Labels: Base design Data Sync Views
249 1
cancel
Showing results for 
Search instead for 
Did you mean: 
aschwartz55
4 - Data Explorer
4 - Data Explorer

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 1

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'.