T
Tom
Thanks, I'll proceed with step-by-step validation.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
----- Lynn Trapp wrote: ----
<snip
BoardTaskAssignmentID P
BoardTaskID FK (to tblBoardTasks
AssigneeID (do a lookup of EmployeeID from tblEmployees
...other BoardTaskAssignment related field
Hi Lynn
Just for clarification - In the above table description did you mean to use a combo box on a form with a recordsource of the employee table, or make the AssigneeID field a lookup field in the BoardTaskAssignment table?
thank
<snip
BoardTaskAssignmentID P
BoardTaskID FK (to tblBoardTasks
AssigneeID (do a lookup of EmployeeID from tblEmployees
...other BoardTaskAssignment related field
Hi Lynn
Just for clarification - In the above table description did you mean to use a combo box on a form with a recordsource of the employee table, or make the AssigneeID field a lookup field in the BoardTaskAssignment table?
thank
L
Lynn Trapp
rpw,
I ALWAYS do lookups from a combobox on a form. I NEVER, NEVER, NEVEr use a
lookup field at the table level. Some say there are some situations where it
might be good -- like initial development -- but I don't agree and don't do
it.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
the AssigneeID field a lookup field in the BoardTaskAssignment table?
I ALWAYS do lookups from a combobox on a form. I NEVER, NEVER, NEVEr use a
lookup field at the table level. Some say there are some situations where it
might be good -- like initial development -- but I don't agree and don't do
it.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
use a combo box on a form with a recordsource of the employee table, or makerpw said:----- Lynn Trapp wrote: -----
<snip>
BoardTaskAssignmentID PK
BoardTaskID FK (to tblBoardTasks)
AssigneeID (do a lookup of EmployeeID from tblEmployees)
...other BoardTaskAssignment related fields
Hi Lynn,
Just for clarification - In the above table description did you mean to
the AssigneeID field a lookup field in the BoardTaskAssignment table?
G
Guest
Hi Lynn
I sorta figured that, but by mentioning "lookup" in the table description I wasn't certain and I figured that other newbies that might be following this thread might not understand your true meaning
thanks again
rp
----- Lynn Trapp wrote: ----
rpw
I ALWAYS do lookups from a combobox on a form. I NEVER, NEVER, NEVEr use
lookup field at the table level. Some say there are some situations where i
might be good -- like initial development -- but I don't agree and don't d
it
--
Lynn Trap
MS Access MV
www.ltcomputerdesigns.co
Access Security: www.ltcomputerdesigns.com/Security.ht
the AssigneeID field a lookup field in the BoardTaskAssignment table
I sorta figured that, but by mentioning "lookup" in the table description I wasn't certain and I figured that other newbies that might be following this thread might not understand your true meaning
thanks again
rp
----- Lynn Trapp wrote: ----
rpw
I ALWAYS do lookups from a combobox on a form. I NEVER, NEVER, NEVEr use
lookup field at the table level. Some say there are some situations where i
might be good -- like initial development -- but I don't agree and don't d
it
--
Lynn Trap
MS Access MV
www.ltcomputerdesigns.co
Access Security: www.ltcomputerdesigns.com/Security.ht
use a combo box on a form with a recordsource of the employee table, or makrpw said:----- Lynn Trapp wrote: ----
<snip>> BoardTaskAssignmentID P
BoardTaskID FK (to tblBoardTasks
AssigneeID (do a lookup of EmployeeID from tblEmployees
...other BoardTaskAssignment related field
the AssigneeID field a lookup field in the BoardTaskAssignment table