[TYPO3-dev] include list view from another table in single view

[edzjins]

 The companies table doesn't contain any field which points to offers.
 The offers table contains field which points to the company ID. Do
 you think it would be easier the other way around?
  --
  edzjins
  Quoting *Dmitry Dulepov <dmitry at typo3.org>*:
> Hi!
> 
>  edzjins wrote:
>  >  Sorry for the mail a few minutes before, something went
> wrong. Here
>  >  it goes again, hope correctly this time.
> 
>  Don't send from the Inbox'es web interface, that's all ;)
> 
>  >   &#160;&#160;I've designed a catalog-type extension. It
> contains of
>  >  catalog
>  >   &#160;categories, which contain catalog companies, which
> contain
>  >  company
>  >   &#160;offers and company details. The thing is, when viewing
> the
>  >  single
>  >   &#160;view &#160;of a company, i see information about this
> company.
>  >  The thing I
>  >   &#160;need in &#160;addition to this, is to show the offers
> of this
>  >  company. The
>  >   &#160;companies &#160;are stored in DB table
> "tx_erkatalogs_firms",
>  >  the offers
>  >   &#160;are stored in &#160;DB table "tx_erkatalogs_offers".
> Offers
>  >  table have a
>  >   &#160;field which is a &#160;database relation to the
> company.
>  >   &#160;&#160;Please point me what to do to output all the
> offers of a
>  >  company in
>  >   &#160;company single view.
> 
>  It depends on how they are stored. Normally there are just
> comma-separated
>  numbers that you can use to fetch records from associated tables.
> Have a
>  look into that field in mysql table.
> 
>  --
>  Dmitry Dulepov
>  TYPO3 core&security team member
>  Twitter: http://twitter.com/dmitryd
>  Read more @ http://dmitry-dulepov.com/
>  _______________________________________________
>  TYPO3-dev mailing list
>  TYPO3-dev at lists.typo3.org
>  http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev