Emulating Notes View

[CaptainBalrog]

Hi there.
I was wondering if its possible to emulate the way lotus notes views work using a query.

Say i had three different tables for three different order types and each table has several common fields like datecompleted,amount and customername.

Is it possible to create a query that will display those three fields in three columns even though they are from three different tables?

If not a query is there any way to achieve this in access?

Any comments would be much appreciated chaps.

 

[neileg]

Yes, a union query will join like that. However, what you propose is a bad design. You should have one table with an order type field and when you need to separate out the order types you do this with a select query.

 

[CaptainBalrog]

Hi, thanks for the response. I know what your saying about the design but trust me what i'm going to use this for does make sense, i just gave a bad example.

I'm starting to get the mindset for access now i think, its hard to get out of the notes mentality after three years of it. Thanks again.

 

[neileg]

I don't trust you! But it's your database.