i need a brainstorm

V

vassilis

hello ppl..
there r 2 tables related ,in the first one there is a field "total days
off" and on the second table there is another field "travelling days" ( for
exapmle)...i was wondering if there is any way, after checking a "yes/no" box
on the second table the value from the "travelling days" to be added on the
"total days off" on the first table...
im sorry if im asking much but thanks anyway....
 
D

Douglas J. Steele

It's possible, but it's a very bad idea. What happens if Travelling Days
changes? Your data in the first table will now be incorrect.

It's far better to create a query that joins the two tables, and do the
calculation in the query, rather than trying to permanently change your
data.
 
V

vassilis

i think u have right...ill try another approach from the queries...thanks for
the response
 
Top