var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What fields should I use iin a relationship
There is a little background to this question in my first thread found here
If you read that you'll see the schema I'm using and that I'm making a relationship change. But I'm not sure what fields to involve in the new relationship.
These are the relation ships as they currently are:
And I'm proposing to relate the Log table to Staff_on_project by a combination of the staff_id and project_id fields, instead of linking the Log table directly to project.
Does this sound right?
The primary keys need to match up to your two foreign keys (project_id and staff_id).
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "