Linking rows or columns

[Mike Brown]

i want to link the columns within my table, well im not sure if link is the
correct statement, basically i want it so that if the information in column A
is one thing, column B will automatically display predetermined information

 

[KARL DEWEY]

That is done in a query, form, or report using an IIF statement but not in a
table.
Column_B: IIF([Field1] > 15, "Bad", "Good")

 

[Mike Brown]

If I create a form and link the columns will it change the information in the
table itself? or just on the form?

That is done in a query, form, or report using an IIF statement but not in a
table.
Column_B: IIF([Field1] > 15, "Bad", "Good")
--
KARL DEWEY
Build a little - Test a little

i want to link the columns within my table, well im not sure if link is the
correct statement, basically i want it so that if the information in column A
is one thing, column B will automatically display predetermined information

 

[KARL DEWEY]

Just the form. You should not store calculated data due to the fact that if
something changes then the stored data would be wrong. Just calculated as
needed for display in a form or report.

An exception to storing calculted data would be where you need to record
cost at a given time due to price changes and therefore would also need to
record the date when it was correct.

To make the change in the table you need an update query or event to use Set
Value.
--
KARL DEWEY
Build a little - Test a little

If I create a form and link the columns will it change the information in the
table itself? or just on the form?

That is done in a query, form, or report using an IIF statement but not in a
table.
Column_B: IIF([Field1] > 15, "Bad", "Good")
--
KARL DEWEY
Build a little - Test a little

i want to link the columns within my table, well im not sure if link is the
correct statement, basically i want it so that if the information in column A
is one thing, column B will automatically display predetermined information