0

How to make a field that compile datas from an other table in an array

Good evening,

I am quite new to dtatabase and here is what I want to achieve. I will use an example from the tutorials video : 

I have a table that describes an hotel. This table is linked to another table that describes the rooms. This room table is linked to a table that describes the clients of this room.

Capture d’écran 2019-09-24 à 15.30.58

Each record of the room table shows me the customers that stay in this room, for example this is the record of the room n°100 :

Capture d’écran 2019-09-24 à 15.36.29 

What I want is to have an array that compile all the customers of all the room in the hotel table :

Capture d’écran 2019-09-24 à 15.34.47

But I don't succeed with this...

any idea ?

 

regards

1 reply

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    Hi, 

    If I understand you right, you want to see all customers that are listed in the customers table. 

    So you view from the layout elements and show the customers table.

    Kind regards, Jörg

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 1188Views