How to ? assign variables from a linked table ?

[Tibo51]

Hello

I've a table called ps_team to store data that are shared between several customers (team name, team address, team post_code, team cite, ...) The primary key of this table is "id_team".

I've added 'id_team' in the ps_customer table (a customer car be membre of one team only)

When the customer log in I need variables from the team to be assigned. I know how to to it for fields in the ps_customer table, but not from a linked table.

Could anybody help me or give me the adres of a tutorial.

Thank you in advance.

Tibo