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! :)