Combox

  • Thread starter Thread starter Ranjit kurian
  • Start date Start date
R

Ranjit kurian

I have a form called as 'frm Task' and this form takes the information from a
query,
frm Task has two columns Name, Report, and this form is in Datasheet view
Now I need to insert a column called as Assign Task into form 'frm Task' and
this Assign Task should be a combox and the Assign Task will pick the data
from a table called as Assign Name, and this table is not linked to anything
, we are just assigning the name to the task as per our wish.

the frm Task should look like the below
Name, Report, Assign Name
 
On Fri, 26 Sep 2008 12:10:01 -0700, Ranjit kurian

I think I understand what you mean, and if correct you are making a
BIG mistake. The table *does* need to be linked to the primary table.
I see your tables as:
tblTasks
TaskID autonumber
TaskName text(255)
TaskReport text(255) 'Not sure about this
AssignedToID int

tblEmployees
EmployeeID
EmployeeName

And an enforced referential integrity link between
tblTasks.AssignedToID and tblEmployees.EmployeeID

Can we get on the same page on the above?

-Tom.
Microsoft Access MVP
 
Back
Top