AnsweredAssumed Answered

two portals in one single layout

Question asked by franzele on Jan 13, 2010
Latest reply on Jan 13, 2010 by philmodjunk

Title

two portals in one single layout

Post

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

 

Products

Code

ProducerCode

DistributorCode

<other data>

 

Companies

Code

<other data>

 

I use two table occurrencies for Companies that are related with Products this way

 

Companies prod::Code = Products::ProducerCode

and 

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

 

Company

<other data>

produced                        distributed

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

Outcomes