Choose from a listbox multiple attributtes and save multiple records in a cell table

Choose from a listbox multiple attributtes and save multiple records in a cell table

  

I've only been playing with this product for a day and I am neither a web developer or a DBA.  I created a query that joins results from several other entities.  Some of the results look like this:


1900-01-01 00:00:001900-01-01 00:00:0070PneusAudiA358-60-OTAntónio cocotgt3

1900-01-01 00:00:001900-01-01 00:00:0070PneusAudiA358-60-OTAntónio cocoRafael5

1900-01-01 00:00:001900-01-01 00:00:00120Filtro de arAudiA358-60-OTAntónio cocotgt8

1900-01-01 00:00:001900-01-01 00:00:00120Filtro de arAudiA358-60-OTAntónio cocotgt9

1900-01-01 00:00:001900-01-01 00:00:0020
Bmw320d20-31-FGAna dfdfRafael18

1900-01-01 00:00:001900-01-01 00:00:0070PneusFerraritestarossa58-60-OYAnatgt7



How can I get the table to display the data like this:


1900-01-01 00:00:001900-01-01 00:00:0070Pneus,Filtrodear,oleodemotorAudiA358-60-OTAntónio cocotgt3

1900-01-01 00:00:001900-01-01 00:00:0070Pneus,FiltroAudiA358-60-OTAntónio cocoRafael5

1900-01-01 00:00:001900-01-01 00:00:00120Filtro de arAudiA358-60-OTAntónio cocotgt8

1900-01-01 00:00:001900-01-01 00:00:00120Filtro de arAudiA358-60-OTAntónio cocotgt9

1900-01-01 00:00:001900-01-01 00:00:0020Oleo,pneus,FiltroBmw320d20-31-FGAna dfdfRafael18

1900-01-01 00:00:001900-01-01 00:00:0070Pneus,FiltroFerraritestarossa58-60-OYAnatgt7


Hi André,

From this post, I am not 100 percent sure what you are trying to achieve. Can you give a little more details so I can try to help you out?

Justin

Hi Andre,

I think first image is a result of Query and second image is data grid which you would like to see on screen, correct?

You can use this query inside preparation of any form, use ListRecords widget on form and give spurce Record List which is output of this query.

You will be able to see data grid.

Hope this helps.

Thanks and Regards,

Suraj Borade

Hi Andre,

If you can attach the oml it would be great to understand your problem.


Regards

SK