getting data from multiple tables

[BizLink]

Dear Friends.....I'm new here and also new to MS Access 2000.

I've built a database...the primary reason for this data base is to pull records. I don't even need to create queiries....I can get the data I want by simply creating advanced filter/sorts.

However....that only seems to work on one table at a time....is there a way to create advance filters/sorts for multiple tables at once?

Look forward to your reply.....

 

[mikey69]

Yes - but you have to define realtionships between the various tables, and preferably make sure that the tables are correctly designed.

Once you've got relationships sorted out, simply put two or more tables in the query grid, select the fields you need and your data wil appear in a single trable.

 

[BizLink]

Thank you...I was thinking that was the way to do it...it's just easier to ask someone who knows.

I prefer to run these filters in form view. I can see how you can use the relationship scenario for datasheet view, but how would you do it in form view?