Need help with Tables Design and Relationships

[Tom]

Thanks, I'll proceed with step-by-step validation.

 

[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

 

[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

----- 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

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?

 

[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

----- Lynn Trapp wrote: ----
<snip>> BoardTaskAssignmentID P
BoardTaskID FK (to tblBoardTasks
AssigneeID (do a lookup of EmployeeID from tblEmployees
...other BoardTaskAssignment related field

use a combo box on a form with a recordsource of the employee table, or mak
the AssigneeID field a lookup field in the BoardTaskAssignment table