dear all,
i have a table called task and other one called owner , each of them has
only one column which like it's name, and there is onther table which
consists of 3 columns the task, owner and points where the task is a lookup
column to the taks table and the same as the case column,
where my form consists of this three fields
* owner
* task
* points
what i want that when i choose the owner and the task automatically i got
the points, i know tht this can be done by dolookup but hoiw can i make it
for multiple chooice at the same time as the points are different according
to the owner and task.
i,e. as shown in the following table :
owner task points
a b 6
c a 7
a a 5
d b 4
and so on,
Ahmed