2. PHPRunner General questions
  3. [SOLVED]  Multiple records on one single form/section
This topic is locked
[SOLVED]

 Multiple records on one single form/section

 		3/2/2011 5:32:00 PM
PHPRunner General questions
Z
 zeth385 author

Well... again, I'll try to explain it smoothly, so you can catch my point:
We receive several documentation at my office. This documentation contains SEVERAL information that has to be captured on a database. The information is then sended to another area to analize it, and then they return us back their opinion. The problem is that many of that info is directed not only to one area, but to several others. And in the database, we need to capture it as it comes to us... Let me show you some fields of the form where we capture the info:
Document_Name

Docuemt_Date

Document_Number

General_Info

Sender

Attending_Areas

Areas_Opinion

Areas_Opinion_Doc_Date

Areas_Opinion_Doc_Number

Area_Manager*

and so on... I work @gov so, you know... there´s a lot of Documentation...
What I would like to do is that the fields marked with asterisk, can be captured as many times as attending areas are... I thought that using two different tables may help, and then link them with Master-Details stuff... but the problem is that they want to capture the info IN ONE SINGLE FORM... so that's why I'm getting desperated!!!
Please, any suggestions??? HEEEEEELLLLLLLLPPPPPP!!!
I'm using PHPRunner 5.3 Build 6843
Thanks in Advance!
Sergey Kornilov admin 3/3/2011

If you link two tables as Master-Details you can add both master and details on the same page. Hopefully this is what you looking for.
Z
 		zeth385 author 3/3/2011



If you link two tables as Master-Details you can add both master and details on the same page. Hopefully this is what you looking for.


Thanks... but, How can I do that... The only thing I can do is see the master as a regular add page, but the details table appears as list, and it only can be edited INLINE... maybe I'm doing something wrong, or missing a step while linking the tables...
Again, thanks for your help!
I'm kinda newbie with this...
Sergey Kornilov admin 3/3/2011

This is correct, details table should appear as a list. Not really sure what would be the other way to add multiple records at once. Probably you can supply a screenshot that explains how exactly your form is supposed to look.
Z
 		zeth385 author 3/7/2011



This is correct, details table should appear as a list. Not really sure what would be the other way to add multiple records at once. Probably you can supply a screenshot that explains how exactly your form is supposed to look.


Ok... here's the screenshot:


So this is how the add page should look like... Now, it would be great if besides displaying it this way, everytime user saves something on the details page, this form (details) resets so they can continue adding new records, and when they click save on the master table, they save the whole thing... I understand it's kinda complicated, but it would be great if you can help me with this... I understand that PHPRunner only displays the details page as a list, that can ONLY be edited INLINE... but, there's always a way to make this work by programming something on php, right?
Thanks again for your help.
Sergey Kornilov admin 3/7/2011

I guess you going to need some code written. Here is an example that shows how to update two tables at the same time:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm
Z
 		zeth385 author 3/7/2011



I guess you going to need some code written. Here is an example that shows how to update two tables at the same time:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm


Ok, I see... I thought it was going to be a little bit more complicated... And, what about displaying both tables as the image above? Can it be done with code??
Thanks!!!
Sergey Kornilov admin 3/7/2011

As a simplest solution you can modify SQL Query joining master and details tables. This gives you the option to display fields from both tables on the same form.
Z
 		zeth385 author 3/8/2011

Ok, I'll try it and tell you what happened.
Gracias!