AnsweredAssumed Answered

Can a portal contain data from two tables?

Question asked by SwissMac on Mar 20, 2010
Latest reply on Mar 21, 2010 by SwissMac

Title

Can a portal contain data from two tables?

Post

I have a simple four table FM10 database. Three tables are data tables, and one a relational table to allow a one to many to one link. These tables are linked by ID number. The tables are:

 

dContract with Primary Key contractID

                 |

one to many relationship

                 |

rContractCompany with Foreign Key contractID and Foreign Key productID

                 |

many to one relationship

                 |

dProduct with Primary Key productID

                 |

one to many relationship

                 |

dPurchase with Primary Key purchaseID and Foreign Key productID

 

 

I want to show all the information on one Layout. The data from the first table is displayed on a normal view. The data from dProduct is shown on a Tab, and the Tab contains a portal in order to show the information from dPurchase. The problem is, I can only display the ID number of the products in the portal that shows the purchase info, and not the name of the item which is what I really want to know.

 

How can I get the portal to show the Product Name as well as the productID? Or should I use an alternative means of showing this info?

 

TIA

Outcomes