Importing two related databases - how to link them

[Phil77]

Hi everybody, newbie here!
I've tried searching first but couldn't quite find the answer I was looking for...

We are working on custom modules for a vertical application using sugar 5.2 (5.5 is still to buggy ).

I have one master database and four supplementing databases. They all have the same unique identifier field which is NOT the name field - one master entry can have multiple entries from one supplemental database belonging to it.
I like to display an entry in the master view, displaying respective entries from the four supplement databases as sub-panels. I've managed to display a sub-panel (created a one-to-many relationship in the mother database with the child) but with no content displayed, since I couldn't tell the software which is the linking field?!

Thanks for your help and happy holidays!

Philip

[eggsurplus]

There are a few ways of doing this. One of which is to create a custom module for each of these subpanels and then overriding the bean so that the retrieve and list queries pull from the supplemental database.

[Phil77]

Thanks for the quick response!
I do have every subpanel in a separate module, but you've lost me on the second part of your explanation.
Any chance you could give me an example?

Thanks again!

Philip