Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

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?
0
j_rameses
Asked:
j_rameses
  • 5
  • 4
1 Solution
 
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
 
lesouefCommented:
but you said the value list was inside the portal... so is it in or outside?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
j_ramesesInfo Sys MngrAuthor Commented:
Administration, please cancel this post.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now