Hi

Can anyone suggest the best way to display records in columns on the same layout.

For example: I may have a database that list activities for individuals on certain dates. So for a single date I may have 3 individuals with information that I would like to display on a single layout in columns. I have achieved this using a related tables but that is restricted to the number I create manually.

Thank you for any help.

Eddie

Table View (Switch the View in Browse Mode)

List View (create one to from scratch using the Columnar List option)

or maybe you need to create a

Portal using relationships.

Lee

Thank you for the reply but I am talking of actually having the separate record data in different columns on the same layout. The Columnar layout option display each record in a row, no good. Other databases can do this. Is there anyway that Filemaker can do this?

Edited January 20, 200620 yr by Guest

I'm sure it can, but by your description of what you want, I haven't got a clue as to what you mean.

I suggested the portal, have you checked it out.

Lee

Thanks again Lee for your reply.

Portals display information from a number of records but again display in rows.

If you can imagine a database that has one table with date, name and then several fields of information. I want to be able to view 2, 3 or more names side by side on the same layout filtered by date. So on the 1/1/2006 I may have John and Peter and display those two records next to each other with up to 20 fields in a column view.