Filtering Data on forms using combo boxes (1 Viewer)

[snehal0909]

I have 4 tables in my Asset manager database.

1) Desktop PCs
2) Monitors
3) Locations
4) Company

the tables LOCATIONS & COMPANY are lookup tables for DESKTOP PCS & MONIOTORS TABLES. - see image and database attached

Pls Note: I still need to make heaps of changes in the db.

IS THERE ANYWAY I CAN SORT & MAKE ALL THE ASSETS COME UP IN ONE FORM/REPORT LIKE THE FIRST FORM IN THE DATABASE SHOWS?
WHAT SORT OF QUERIES DO I HAVE TO MAKE TO MAKE THAT HAPPEN?

Thanks!

 

[DCrake]

You are restricting the support to users with A2007, try submitting sample mdb's in an earlier version where possible.

David

 

[snehal0909]

You are restricting the support to users with A2007, try submitting sample mdb's in an earlier version where possible.

David

Hi David,

This database has attachment fields (data type) so i can not save it as mdb.
But i will keep that in mind for future posts.

Thanks!