This topic is locked

comment for each product

4/19/2018 7:13:19 AM
PHPRunner General questions
N
nagendra802000 author

Hi,
I want to add comments for each product. If user is viewing a product he should be able to see the comments regarding to that products.
Tab 1 Tab 2

Iphone 6s Comment 1

$499 Comment 2

13 MP Camera Comment 3
and so on......

admin 4/23/2018

Usually this kind of functionality is achieved via master details. Products should be your master table and Comments should be details.
Take a look at Marketplace for instance:

https://xlinesoft.com/marketplace/products_view.php?editid1=54
There are products and there are comments and they are related to each other as Master-Details.

lefty 4/25/2018



Usually this kind of functionality is achieved via master details. Products should be your master table and Comments should be details.
Take a look at Marketplace for instance:

https://xlinesoft.co....php?editid1=54
There are products and there are comments and they are related to each other as Master-Details.


So you want to put the product field and comments in the same view . I guess.
Not sure on your question but why not just concat product with comments .

Concat(Productdescription, ' / ' , Comments) in lookup wizard display expression , when he picks a product. ? This is for Mysql.
If comments is separate table and has no connection to product then your design is wrong .
If you have comments on a record connected to the product then use above concat idea. If you have product and comment connected like admin says above in details table ( other table ) . Then you can use autofill , where using lookup wizard use autofill meaning if someone select s a product it will auto fill the comments from the master table. See lookup wizard documentation . It's pretty straightforward.
So you have multiple options depending on how you designed the tables.