Refreshing a field look up

In the middle of entering a transaction for Table A In Form B and realize that I do not have a value I need in a look up field for table D.

So I go to the file maintenance in app Form C and add the value to Table D

I then go back to the already open Form B to complete it, but of course it doesnt recognize that a new entry was made into table D

I tried a Refresh button but that just closes the form

Anyone have a solution?

In the ‘Lookup Settings’ of your field in Form B, click on the ‘Create link’ button.

Create a link to your ‘Form C’ to update the value in Table D.

When you close the form, the new value will be available.

TY so much mzach!! Much appreciated