Putting code behind tables in MS Access 2007?

[ndb]

Using an example:

I have three tables; tbl_weight , tbl_height , tbl_bmi
How do I make tbl_bmi automatically use the weight and height values (height/weight) to determine the tbl_bmi values?



Is there a way to store code behind the tables as if I was in MS excel?

Thanks in advance.

[ItsMe]

Have you tried using queries to get the information you need?

[June7]

Code goes behind forms and reports and in general modules.

As ItsMe suggests, you probably need to do a query.

Post examples of your data.