How to create multiple views for a table?

[erichsen]

I have two tables: BUDGET and PROJECT

I want 2 views for each table (+/- columns).

I tried crteating new views based on these tables but the
settings are never preserved or get mixed up.

I also tried creating copies of tables with deleted or added
columns - but this does not help create the view I need.

Any advice?

 

[PDQBach]

From another answer:

A view consists of the table and filter. Since you want different columns you are changing the table.

Your answer: create tables Budget1 and Budget2 (each having just the columns you want displayed). Then create two views (VBudget1 and VBudget2) using the appropriate table (and, of course, filters).

Project (which is *very* old) uses "table" when it means (in SQL terms) a "view" and uses "view" when, in SQL terms, it means a "where clause" (to implement the filter).

If you don't understand that, don't worry. All you need to know is that you need to create a Project Table for each project view. You have four views that you want ... do the math.