How to join two forms in one view?

How to join two forms in one view?

Hi All,

My goal is to create an view for one form/table that contains referenced fields from another form/table. For example - I want to show the list of employees, and the name of the department from the departments table, referenced via the department ID that is contained in both tables.

For SQL oriented people (like myself) this is simply a join operation...

Any help will be greatly appreciated.

Thanks,

Tal.