dynamic values in tables

[johann201]

Hello everybody! i want to create a table consisting of 2 columns. one column may contain constant values and the other has to contain dynamic values (values of the second column must depend on the values of the first column). For example if the constant of the first column is ID then the variable of the second column will be ID+5. Something like that below

Column 1 Column 2
ID1 ID1+5
ID2 ID2+5
ID3 ID3+5
. .
. .
. .

Could anyone give me a tip about that? Thank you in advance...

johann

 

[boblarson]

How are you acquiring the "dynamic" values? What is the concept behind this? If you give more information, we sometimes can come up with better answers than with just very limited info (like what you have given).

How are you entering the data into the table? Is it via a form, via code, etc.

 

[The_Doc_Man]

If the dynamic value is computed from something else, perhaps you really don't want a computed value stored in that table. Instead, you want a query that computes what you need and then you use the query rather than the table for a recordsource. Most things that need recordsources don't really care whether they use a table or a query for that source.