How do i get the portal to display data from a drop down box that pulls data from a different table?

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?
j_ramesesInfo Sys MngrAsked:
Who is Participating?
 
j_ramesesInfo Sys MngrAuthor Commented:
Administration, please cancel this post.
0
 
lesouefCommented:
the problem is not the portal but in table B
the field you wanna get altered is in table B, right?
so define this field as auto-enter in table B. the relatiosnhip you get the data from must be using the field you change with the dropdown value. more if you supply the files...
0
 
j_ramesesInfo Sys MngrAuthor Commented:
i want to be able to select a value from the value list(the values comes from table 'b') and display the rest of the fields related to that value inside the portal.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
lesouefCommented:
but you said the value list was inside the portal... so is it in or outside?
0
 
j_ramesesInfo Sys MngrAuthor Commented:
it is inside the portal
0
 
jvaldesCommented:
Can you provide the application so I can see the relationships and the value table reference?
 
0
 
lesouefCommented:
ok, so all you need are auto-entered fields in table B.
yes seeing the file, even empty, would help.
0
 
j_ramesesInfo Sys MngrAuthor Commented:
our database got corrupt and we can not open it.
we get an error message.
i think we are going to have to start from scratch again.
thank goodness we did not have data, yet.
0
 
lesouefCommented:
backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup? backup?
where is the backup??
as soon as soon you start a project, do the backup procedure first, always.
0
 
j_ramesesInfo Sys MngrAuthor Commented:
i decided i will not use a portal since it will be pulling only one set of data.
thank you all for your time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.