New Db Setup Tables/Forms

On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to give me 17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1, right?
--

John W. Vinson [MVP]

LOL, you must know my boss, too, John! g


"John W. Vinson" wrote in message
...
On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to give me
17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1,
right?
--

John W. Vinson [MVP]

The best thing about having all tasks as Priority 1 is that I get to decide!
My boss doesn't like hearing that, but he understands...

Jeff

"tina" wrote in message
...
LOL, you must know my boss, too, John! g


"John W. Vinson" wrote in message
...
On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to give
me
17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1,
right?
--

John W. Vinson [MVP]

On Tue, 07 Jul 2009 11:59:40 GMT, "tina" wrote:

LOL, you must know my boss, too, John! g

Anne used to occasionally use the notorious DEF priority system:

Do Everything First
--

John W. Vinson [MVP]

John W. Vinson wrote in
:

On Fri, 03 Jul 2009 01:37:28 GMT, "tina"
wrote:

aha, Jeff, so you're the one who helped my boss figure out how to
give me 17 things to do at once! g

And if the tasks table has a Priority field... they're all set to
1, right?

Worse still:

Some are set to priority 1 and others to priority 2.

Guess which ones the boss will ask you 2 hours later if they are
done yet? If you guessed PRIORITY 2, you're right!

In other words, boss's often aren't very good at setting priorities.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

John W. Vinson wrote in
:

On Fri, 03 Jul 2009 01:37:28 GMT, "tina"
wrote:

aha, Jeff, so you're the one who helped my boss figure out how to
give me 17 things to do at once! g

And if the tasks table has a Priority field... they're all set to
1, right?

Worse still:

Some are set to priority 1 and others to priority 2.

Guess which ones the boss will ask you 2 hours later if they are
done yet? If you guessed PRIORITY 2, you're right!

In other words, boss's often aren't very good at setting priorities.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

wow, an understanding boss! ...will you trade? bg


"Jeff Boyce" wrote in message
...
The best thing about having all tasks as Priority 1 is that I get to
decide!
My boss doesn't like hearing that, but he understands...

Jeff

"tina" wrote in message
...
LOL, you must know my boss, too, John! g


"John W. Vinson" wrote in message
...
On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to give
me
17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1,
right?
--

John W. Vinson [MVP]

wow, an understanding boss! ...will you trade? bg


"Jeff Boyce" wrote in message
...
The best thing about having all tasks as Priority 1 is that I get to
decide!
My boss doesn't like hearing that, but he understands...

Jeff

"tina" wrote in message
...
LOL, you must know my boss, too, John! g


"John W. Vinson" wrote in message
...
On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to give
me
17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1,
right?
--

John W. Vinson [MVP]

Thank you for the input. IT WORKED! I did have to take another look at my
relationships. Now everything is running smoothly. I was able to build my
Reports and Forms and some Query's yesterday with ease.

The only thing left for me to do now before I'm done is to setup the
switchboard.

Thanks again.

Jeff Boyce wrote:
Sorry, I used a prefix that usually stands for "table-relationship" (AKA,
junction table, resolver table). These are used to handle many-to-many
relationships (and if an employee can work on many projects ... over time
... and a project can have many employees working on it, you have a
many-to-many relationship).

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff - I can tweek the empl and project table to get this, but can
you
[quoted text clipped - 37 lines]
single
form. Can someone give me some direction here??

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200907/1

Not so sure you want this one ... he's also the one who says "Now!"

Jeff

"tina" wrote in message
...
wow, an understanding boss! ...will you trade? bg


"Jeff Boyce" wrote in message
...
The best thing about having all tasks as Priority 1 is that I get to
decide!
My boss doesn't like hearing that, but he understands...

Jeff

"tina" wrote in message
...
LOL, you must know my boss, too, John! g


"John W. Vinson" wrote in message
...
On Fri, 03 Jul 2009 01:37:28 GMT, "tina" wrote:

aha, Jeff, so you're the one who helped my boss figure out how to
give
me
17
things to do at once! g

And if the tasks table has a Priority field... they're all set to 1,
right?
--

John W. Vinson [MVP]