How to create relationship between tables in database

[ahmed.elkaffas]

I assume that your table “Meal” stores all the meals ordered by a specific “User”. In this case, you need to add the user always to the “Meal” table as it won’t get populated automatically even though it’s the 2 tables are linked together.
I guess in your application each user orders a “Meal” then saves it; in this case please always add “Current User” to the “Langues” field of your “Meal” table when the user clicks “Save” on ordering a “Meal”.

@annick-boisset

What type of workflow should I set up so that ‘Prénom’ gets filled with the data recorded in the User table?

If I understand correctly, I believe you should always add “Current User’s Prénom” in your table “Repas”.

Hope this helps !