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.
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.