1 member in 2 teams

[Phong_Lam1]

Hi all, I have 2 tables:  team and members. I set table members referenced to table team. So in the view of team, below it I will see the members in that team. But I get stuck, What to do if one member is a member of 2 teams (not one)?

[jyothis_m]

Instead of using Column Type as REF you can use ENUMLIST (mutiple teams selection possible) with Base Type of Enumlist as REF to the TEAMS Table

[Marc_Dillon]

This is called a "many to many relationship". You should definitely search that for more info. Using an Enumlist is certainly one solution, but it is often far from optimal. The more "standard" solution is to add a 3rd table to act as a "bridge" or "join" table. Again, you should find more info about that if you search for it.