you need a join table to solve the many to many relationship problem.
maybe name it HOTELS_PRODUCTS
i justwant it to know witch tools to use in filemaker to build it, or it list on witch to look at
grab the filemaker training series and work throiugh it. youll be glad you did because it covers alot.. youll especially want to look at the info in table and field creation.
so i need to resolve only one specific problem
if i make portal and inside i can pick up between the hotels, what i can actually need is directly to show inside all records of the hotels. So each week to put the numbers sold inside this portal coresponding for the hotel. Because all the hotels will have results every week
If I understand you correctly, you only have one product, so you actually do not have to have a table for the product, you only have to focus on the a) hotells, b) the quantity sold each week. As I can see it, you only need 2 tables, one for Hotels and a second for QuantityEachWeek. Between them you have a one-to-many relationship. With that I mean that a Hotel have several weeks but each week-record is only connected to one hotel.
The ralationship between the two tables is with IDf_Hotel to ID_Hotel. Remember to permit creation of new records through this relationship!
In the layout Hotel, you put a portal that shows the week numbers and the quantities sold.