Multiple tables from one main table

[Nitrox]

Hi there,

i have a big number of sales staff..and broken them into different teams.

I have one TABLE1 with all their names, i need to have table which links to TABLE 1
All the fields are the same except team field. Therefore i need table 2 to only show me all fields and TEAM ALPHA only.
In total i got 46 teams therefore it is big.

Can this be done?


How do i do it?

Please advice

[pbaldy]

The normalized design would be to leave them in one table. You can use any number of methods to restrict forms and reports to a given team. Parameter queries is one method, this is another:

BaldyWeb wherecondition