Hello everybody,

Im trying to make a database and after many hours watching tutorials, i cant find a solution for my problem.

So, what I have is only 1 product that its selling by many hotels. What I did so far is my layout with the many hotels.

But i need a swell another layout where im going to put each week database how many sells each hotel did. Something like many actors and many movies example.

And its get more complicated when im trying to see the quantity of how many numbers sold each hotel, each week.

I try to put portal in the weeks layout where i can see every hotel and then put the quantity of numbers sold.

On Excel its so simple. On the left side I put the hotels name and on top the week. As Data i put the result of the number sold. This way i can see each week witch hotel how many sold and each hotel how many sell every week. How to do that in FileMaker

I get really stuck

Please give me some advice.

Thanks in advance!

PS: Sorry about my english

you need a join table to solve the many to many relationship problem.

maybe name it HOTELS_PRODUCTS