Hi,
Depending on your model this should be achievable.
If you have a structure of:
Master Table -< Master Table's Teams >- Teams
| /
Child Table
So, a table for all teams, a new one for Teams that belong to the Master Table.
With this you can link whatever teams you want on the master table, and from the child table you then have a lookup to the Master Table's Teams (N:1 Relationship)
Then on the Child Table's form use a Filtered Lookup to only show Master Table Teams that are already linked to the Child Table's Master
Once you select the Lookup field on the Child Table's form you'll see these options:
You should be able to select the Master Table lookup. This will ensure you only see teams from the Master.
hope this helps and that I didn't make it too confusing
