any ideas??

  • Thread starter Thread starter buckeyfan4472
  • Start date Start date
B

buckeyfan4472

I'm currently working on a database but i keep hitting road blocks. mainly
from a lack of knowledge. I'm in the military and i have to track equipment
such as...what type of equipment, who signed for it, what is the serial #,
what company it's in, etc... I'm weak with queries and relationships. I want
to be able to type a person's name in to show everything he/she is signed for
from different tables. I'd appreciate your help.
 
Why from different tables? What is your table structure like now?

I would assume you would have the following tables

Clients
Equipment
Signout Log

Then you can create a simple query using the 3 tables to list who has what.
Use the report's sorting ability to group the listing by ClientID so that
each individual's items are listed together.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
If you are using Access 2007, take a look at some of the templates that
Microsoft provides. They might already have done most of the work for you.
 
Back
Top