Page 1 of 1

Base the value of a field in one table on a field in another table

Posted: Mon May 29, 2023 7:22 pm
by rkopp01234

Hi there,

I was wondering how I can set the value of a field A in table A based on field B in table B?

Do I use events for this? Which code can I use?

Thanks.

Rainer


Re: Base the value of a field in one table on a field in another table

Posted: Tue May 30, 2023 8:03 am
by MichaelG

If you mean looking up a value from another table, set up the Lookup Table.

If not, please explain more clearly what you are trying to do.


Re: Base the value of a field in one table on a field in another table

Posted: Tue May 30, 2023 12:20 pm
by rkopp01234

I am trying to set the value of a field programatically without any user interaction, such as lookup tables, where the user selects a value manually.
The value of field A in table A should be set automatically to the value of field B in table B.

Hope this makes sense?


Re: Base the value of a field in one table on a field in another table

Posted: Wed May 31, 2023 7:28 am
by MichaelG

If you mean auto fill, please read the "Auto fill" section in Lookup Table settings.