Creating tables from a query ran on some other table

[zeenathaf]

Hi,


I have to create a table whose column values change whenever the values in another table change. Can anyone tell me if this is possible in MSAccess. If so how can I do that.

Thanks in advance,
ZAF

 

[Mile-O]

That's a calculated field you are suggesting and should be done in a query.

 

[zeenathaf]

Can you please explain this a little more.My requirement is that whenever a value in the first table changes the corresponding value in another table should change in real time.

 

[neileg]

zeenathaf

The approach you suggest is valid in a spreadsheet, but not a relational database.

In a database, you store your data in tables and you display your data in forms or reports, based on queries or code. Where you have a value that changes in line with data in a table, you should calculate that new value whenever you need to display it. This way it is always based on the most recent data available.