recreating a project

Hello Crozon

Si pour le primaire et le lycée les champs restent les mêmes, tu peux passer par une combobox proposant les deux éléments.
Je pratique de la sorte pour une application de gestion bancaire familiale faite avec MVD (avec l'aide de Sparrow et de Derek).
Une combobox liste tous les différents comptes que je veux gérer et cela fonctionne parfaitement.

Par contre tu devras une table distincte pour les deux écoles avec les mêmes champs.

If the fields remain the same for elementary and high school, you can use a combo box that offers both elements.
I use this method for a family banking application made with MVD (with help from Sparrow and Derek).
A combo box lists all the different accounts I want to manage, and it works perfectly.

On the other hand, you will need a separate table for the two schools with the same fields.

JB

Hi guys
in the attached project I used a combobox (Form 2)
what I need is that Elementary teachers should only be visible for the user "Derek" and high school teacher should be visible for "Identity"
but that combobox shows all the teachers for both users.
How can I fix it?

thank you Derek
It was my bad to confuse you
by "elementary teacher" I didn't mean only the phrase "elementary teacher" . I meant every elementary teacher (about 20 teachers) at a particular school.

Hi Derek.
Sorry, but for Form3 you can't do without a little script, otherwise the new type doesn't appear in other tables without reloading the form.

procedure Form3_TableGrid1_OnChange (Sender: TObject);
begin
  if Form3.TableGrid1.Focused then
  begin
    Form3.TableGrid2.dbUpdate;
    Form3.TableGrid4.dbUpdate;
  end;
end;