My goodness, that simple!

Thanks!

Thanks for your reply. Maybe I have not explained my problem good enough.

I'll try again.

I have two tables:

warehouses

warehouse (pk)

departments

department (pk)

create view as

select warehouse from warehouses ...