2. PHPRunner General questions
  3. Show / Hide another Table
This topic is locked

Show / Hide another Table

 		6/12/2008 6:50:53 AM
PHPRunner General questions
I
 indigo author

Hi,
I have two tables...
Table Name FB:
FID

PID

Rating

Comments
Table Project

PID

Name

Date

Other Data
Both the tables have 'PID' which is a common field.
Now if someone is entering data in 'FB' Table, I want to show the details from 'Project' table when someone is entering a related PID in the FB Table.
For e.g. If someone enters '79' in PID in FB Table, I want to display details of that record from 'Projet' Table.
Can we achieve this using Ajax and Show/Hide logic?
Please let me know.
J
 		Jane 6/17/2008

Hi,
if you set up PID field in the FB table as lookup on the "Edit as" settings dialog on the Visual Editor just use custom expression as display field and concat all fields from Project table in this expression.
I
 		indigo author 6/18/2008

That is possible, yes
However the fields have a lot of data and mere concat function will make everything a little difficult to understand.
Also, Visual Editor does not update the custom HTML changes on the page.

I tried changing the Heading of the page (From ADD NEW RECORD to Insert new Project) and it did not work.

I am using 4.2.379 version.
J
 		Jane 6/18/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.