RE: Basic table/query design

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bruce (Bruce_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 05:13:02 -0800

Can each agent have multiple Contract Start and Contract End dates? If so,
Contracts should be a separate table. Similar question for Managers: can a
manager be associated with multiple contracts? Does a contract involve more
than one agent ? Answers to these questions will guide the structure of your
database. In general, a good way to limit the combo box list to managers is
to add a Manager Yes/No field to the Employees table and use a query limited
to Employees with the box checked as the row source for the combo box.

"Pete McCosh" wrote:

> Hi all. I would appreciate any advice you could give on this and apologise if
> it seems rather obvious.
>
> I'm trying to set up a simple database to handle staff details within our
> office (approx 500 people.) Agents frequently move between teams and one of
> the main things I want to be able to see is a historical trail of what
> managers they have worked for and the relevant dates.
>
> I currently have an Agents table (Pay Number, Name, DoB, Contract start and
> end date) and a Team table (AutoID, Agent Pay No, Manager , Start and End
> Dates in team.) What I am having problems with is working out the best way to
> validate and restrict the entries in the Team!Manager field.
>
> The list of possible managers is a subset of the list of all employees. I've
> tried adding a Boolean field to the Agent table, running a query against that
> to provide a list of valid managers then setting this as a lookup for the
> Team!Manager field, but it still let me enter anything I wanted. I also tried
> creating a third "managers" table with just a list of valid managers pay
> numbers, but I couldn't find an effective way of keeping this updated as the
> list of managers changes.
>
> I want to be able to track a number of things in the same way, but getting
> this first one done properly should show me the way to go with this.
>
> Thanks, Pete

Relevant Pages

  • Re: Gisbey should resign
    ... I think we are discussing Contract 2A at Rugby, ... project managers, but I have known certain of their senior managment to ... good interpersonal skills are not what is required to get ... There is a difference between 'straight talking' and lacking the necessary ...
    (uk.railway)
  • Re: employment advise
    ... I approached him the other day to ask for a managers wage as thats the ... assistants role, but in status) This a partcularly scheming of them as ... Your contract is there to protect you and only do the work required in the contract. ... If what youve done is true, i.e. turned around the job area and completed a major project, then maybe this will look good on your CV for your next job.... ...
    (uk.legal)
  • Re: Gisbey should resign
    ... I think we are discussing Contract 2A at Rugby, ... project managers, but I have known certain of their senior managment to have ... good interpersonal skills are not what is required to get ... have a reputation for straight talking, ...
    (uk.railway)
  • Re: Who Owns the code
    ... I should add that many technical people are often not good business ... managers. ... Hire one or contract with one, to avoid this kind of problem ...
    (borland.public.delphi.non-technical)
  • Re: Submitting is easy once you stop thinking about it
    ... "publish," even in the parts of the boilerplate my agent had taken out. ... Option clauses are standard; ownership clauses are not. ... If it says something like "publisher has an option ... through the relevant part of the contract and then stick a quarter ...
    (rec.arts.sf.composition)