two portals in one single layout
Hi all (my first post...).
Using FM10 demo on a Mac OSX Snow Lepoard, and coming from a good PHP/MySQL experience. Almost new to the FM environment.
I'm planning a one-user rather simple solution that should base on two tables, Products and Companies, 1-N related. Products lists a series of items, and Companies lists data for firms that can be producing and/or distributing the Products.
I'm using this structure
I use two table occurrencies for Companies that are related with Products this way
Companies prod::Code = Products::ProducerCode
Companies distr::Code = Products::DistributorCode
Until now, no problem in showing in Companies a portal with the products the company produces. But now I need a second portal in the same company record showing products the firm distributes, something like this
pr10 - hammer pr21 - screwdriver
pr15 - nails ......
I thought that should have been easy in FM (not a problem in MySQL). But (surely for my minimal experience in FM) it's a lot I'm searching for a solution, but no way.
Would some of you gurus be so kind to give me a hint to this situation?
Thanks a lot