2. PHPRunner General questions
  3. [SOLVED]  Tab View - Add/edit Linked Table
This topic is locked
[SOLVED]

 Tab View - Add/edit Linked Table

 		4/19/2013 12:47:33 PM
PHPRunner General questions
J
 jco author

Hello,
Wondering if anyone can help me out please (using PHPR6.2 Enterprise)
I have two tables; tbl_sitesurvey and tbl_photos. Basically and to simplify things tbl_sitesurvey holds all info pertaining to a site survey, whereas tbl_photos holds photos related to that sitesurvey. I'll have multiple photos per sitesurvey so I have the tables linked "Master: tbl_photos -> Details: tbl_sitesurvey" joined by "tbl_photos.id_sitesurvey=tbl_sitesurvey.id".
On the Add Page of tbl_survey I want a tab where I can add all the fotos related to a particular sitesurvey. Form what I've read the solution involves cutting code from the tbl_photos Add page and pasting it into the Tab element of the tbl_survey Add Page. I just can't get this to work :-( Can anyone tell me exactly what I should be selecting and where I should be pasting it?
Any examples, screenshots would be great!
Thanks in advance
José Carlos
Sergey Kornilov admin 4/19/2013

Once you have linked tables as master-details enable 'Display details on Add page' option. This will allow you to add both master and details records on the same page. You can move the grid with details record to one of tabs if you need to.
I need to add that version 6.2 adds a better option and you do not need to use a separate table to store images. Any single field can store multiple images and this what I suggest to use.
J
 		jco author 4/19/2013



Once you have linked tables as master-details enable 'Display details on Add page' option. This will allow you to add both master and details records on the same page. You can move the grid with details record to one of tabs if you need to.
I need to add that version 6.2 adds a better option and you do not need to use a separate table to store images. Any single field can store multiple images and this what I suggest to use.


Thanks, that did it!

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=70525&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
José Carlos