>OK, so I created a view. One table is tiny, but the other is rather large as most of our tables are. When I browse the created view, it runs a query for about a minute or so then pops up. Is that what would happen if I used the view in a form? would it really take all that time to query each one? If so, that is way to slow and inefficient for us to use that method with our large tables.
How long does it take to simply browse the table(s)? Another benefit of views is to exclude data that isn't relevant. If the user is only viewing certain fields, only include them. If there is a simple identifier to exclude rows from being viewed, you can use a parameterized view, which tends to be much faster than loading the entire table.
SELECT Field1, Field2 FROM mytable WHERE Field1.Value = ?SpecifiedValue
Chris.