Hello,

I been thinking over this one for the past few days with no luck. Maybe someone can help.

I am building a module where I have different Hotels (X number) and each Hotel has different amenities. For that I created a one2many field which inserts the amenities of each Hotel into the amenities table.

Now my problem starts when I need to create the Clients table. For that I have a form view were I am asking for the Client Name, x, x, and Hotel with a many2one field referencing the previous table. In that same form I need to list the amenities that hotel has from the amenities table created above and be able to set a price for each amenity on the list. Each client has a different price even for the same Hotel.

+---------+----------+
| Hotel A | Client A |
+---------+----------+
| Pool    | $34      |
| SPA     | $12      |
| Gym     | $23      |
+---------+----------+
+---------+----------+
| Hotel A | Client B |
+---------+----------+
| Pool    | $74      |
| SPA     | $62      |
| Gym     | $233     |
+---------+----------+

Is there any way I can generate the fields on the fly as soon as the user selects the Hotel? I was thinking if I can do that to save the data into a PricePerClient table where I would have, Client ID, Amenity ID, Price. The Client ID must be the current ID of the form I am seeing.

Any tip/idea will be much appreciated! Thanks! :)