How do i get the portal to display data from a drop down box that pulls data from a different table?
Posted on 2008-06-17
I have a layout where there is a portal.
That portal has a drop down value list that pulls data from a table 'B'.
The table I am working on is table 'C'.
The value list is inside the portal, the portal only has one line item.
What I am trying to do is that when a user selects an item from the value list, the other fields in the portal fill up with the corresponding data that is related to the selected item in the value list.
The value list will have the name of the hospitals that are created dynamically from table 'B', which will also have the address and phone number and fax number.
When a user selects a hospital I need the rest of the fields to get populated with the other data that is related to it.
I have tried it but it does not work. I am hoping maybe I am doing something wrong.
Also, table 'B' has a relation with table 'A'.
None of the fields that refer to "whatever changes you make to other table via this relationship will make changes to this table", I am not sure of the wording since I am writing from home.
What exactly am I suppose to do to make this portal work?