Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Multiple dlookup


Message #1 by "Ahmed khamis" <akhamis@l...> on Thu, 16 Jan 2003 12:29:47 +0200
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



  Return to Index