Access Relationships

[L. Ann]

I am building a database with the following tables: Techs, Equipment,
Workorder Labor, Workorder Parts, Labor Code, and Equipment Returns. I need
to sell the equipment to the Techs and they use them on the Workorder. What
do I need to do to sell the equipment to the Tech's and have it deduct from
their account each time they use a piece of the equipment on a workorder?
What relationship or do I need a query? Any suggestions? Thanks!!!!

 

[Larry Linson]

I am building a database with the following tables: Techs, Equipment,
Workorder Labor, Workorder Parts, Labor Code, and Equipment Returns. I
need
to sell the equipment to the Techs and they use them on the Workorder.
What
do I need to do to sell the equipment to the Tech's and have it deduct
from
their account each time they use a piece of the equipment on a workorder?
What relationship or do I need a query? Any suggestions? Thanks!!!!

I am presuming you know a great deal more about your tables, their contents,
and specifically what your terms mean than what you have told us. If anyone
can assist you based on the limited information you provided, I encourage
them to do so. As for me, if you'd clarify, I would guess someone may well
be able to help...

For example, I do not know wheter your equipment table is description/detail
of equipment, or represents an inventory, nor how you want to select what
equipment to sell to a tech, nor where the tech's "account" is maintained.
All these seem pertinent to the question you asked.

Larry Linson
Microsoft Office Access MVP

 

[L. Ann]

The Equipment Table has Equipment ID, Equipment Name and Unit Price; Employee
Table has Employee ID, First Name, Last Name and etc. If you need more info,
please let me know. Thanks! Ann

 

[L. Ann]

To explain it in more detail. I am using the Service Call Management
Template; the employees purchase the parts and install them on the customer's
workorder (workorder parts). I need a way to track the parts that are sold
to the employees and subtract the part from the employee when it is used on
the workorder. The part number, price and description is in Parts.
Hopefully, this is clearer. Thanks!

 

[Tom Wickerath]

L. Ann,

You might want to consider picking up a copy of this book:

Access and SQL Server Developer's Handbook (Paperback)
http://www.amazon.com/gp/product/0782118046

I believe it is out of print, but it is still available used. The shipping
costs more than the book itself. I recently purchased a used copy (excellent
condition with CD disc) for US $0.39 ($3.99 shipping & handling, for a total
of $4.38). It is written for an older version of SQL Server (version 6), but
this book includes a very through description of a similar database to what
you have described.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[L. Ann]

Thanks for you assistance! I will order one today. Ann