L
lcc
Hi
I have been racking my brain and cannot find a solution, I am sure its
simple but cant seem to find the answer, I have searched previous
posts, tried various relationship linking scenarios, many to many
relationship join table, but cant figure how to link correctly or if
my current table set up is incorrect
I have created an Issues database which for each issue has
the issue (issues_t),
which can have several actions relating to the issue (Actions_t)
and then several update notes(updates_t) for each of those actions
this side of the tables/relationship is fine
My problem lies with the staff relationships. For each issue there is
an owner, accountable and delivery person, (could be the same people)
and then for the action there is a separate delivery person.
Tables
Issues(t) - contains the issue details
SIS ID - Primary key(auto number)
Description
Accountable (lookup from contacts table)
Delivery (lookup from contacts table)
Owner (lookup from contacts table)
Plus other fields
Actions(t)
ActionID - primary key (number)
ActionDesc
AssignedTo (lookup from contacts table)
Plus other fields
Contacts(t) - contains the staff details
ID -Primary key (number)
Name etc
Updates(t)
updateID-primary key (number)
comments
can you please advise the best way to link the contacts to the various
accountable, owner etc fields
Thanks
I have been racking my brain and cannot find a solution, I am sure its
simple but cant seem to find the answer, I have searched previous
posts, tried various relationship linking scenarios, many to many
relationship join table, but cant figure how to link correctly or if
my current table set up is incorrect
I have created an Issues database which for each issue has
the issue (issues_t),
which can have several actions relating to the issue (Actions_t)
and then several update notes(updates_t) for each of those actions
this side of the tables/relationship is fine
My problem lies with the staff relationships. For each issue there is
an owner, accountable and delivery person, (could be the same people)
and then for the action there is a separate delivery person.
Tables
Issues(t) - contains the issue details
SIS ID - Primary key(auto number)
Description
Accountable (lookup from contacts table)
Delivery (lookup from contacts table)
Owner (lookup from contacts table)
Plus other fields
Actions(t)
ActionID - primary key (number)
ActionDesc
AssignedTo (lookup from contacts table)
Plus other fields
Contacts(t) - contains the staff details
ID -Primary key (number)
Name etc
Updates(t)
updateID-primary key (number)
comments
can you please advise the best way to link the contacts to the various
accountable, owner etc fields
Thanks