Queries are beautiful!!!

surendra87

New member
Local time
Yesterday, 18:25
Joined
Jun 7, 2008
Messages
8
It has long been my dream to make databases that will make my life easier....lots and lots easier. now i am taking it to the next level.

anyways, anyone who works on accounting program: Peachtree, Quickbooks, etc. will wonder "how do these people get the names next to the ID of vendors and customers?" its done by queries.

on the ID field (Employee, customer, vendor) click lookup in the design view of the table. combo box, run the query builder. and select the fields you want displayed. its wonderful!

enjoy.

by the way, it took me almost 3 years to learn all these things i know about access.....haha.
 
For anyone who wants to accelerate that learning process, FunctionX has some really good tutorials (free) (including full MS Access 2003/2007, SQL Server, etc.):

http://www.functionx.com
 
ok, i am going to check out the sites. and i want to excel and fast.......i find that there is a huge opportunity in this field!!!
 
surendra87, unfortunately you have stumbled across a crutch that will turn around and kick you, you know where. NEVER use lookups at the table level. Use them in Forms. If you want to see both the ID and the text value for a field, create a query that joins the Order table, for example to the Customer table so you can see the customer name as well as the customer number.
 

Users who are viewing this thread

Back
Top Bottom