Table View Data

Sorry if this is really basic, but here goes....

I have FM 9. My database contains a Project table and a Tasks table that are
related on primary key project_id (hope the lingo is correct!). In Project
form view, I can create a new Project and add multiple tasks in the Task
portal.

But in a Table Layout, I need to list all Tasks records along with
project_id, client and project_name from the Project table.

Assuming I can only show fields from one table in a Table Layout view, do I
create client and project_name fields matching fields in Tasks? Then there
would be 3 matching keys between the two tables - project_id, client and
project_name. Each time a new Task is created in the Project Form portal,
the related project_id, client and project_name fields will populate from
the Project table. Then I can display all fields in table view layout from
the single Tasks table.

I tried this but seemed to get really complicated matches in the
Relationships graph and it didn't seem to work correctly.

Any assistance is appreciated.

Re: Table View Data

On Apr 14, 11:04 am, "Freddy" wrote:
> Sorry if this is really basic, but here goes....

> Assuming I can only show fields from one table in a Table Layout view,

That assumption is incorrect. You can add fields from another related
table to the layout; when selecting what field to add in layout mode,
use the drop downlist of table occurrences above the list of fields to
choose other related tables.

You can do this in any 'view' ( form / list / or table )

-regards,
Dave

Re: Table View Data

> Assuming I can only show fields from one table in a Table Layout view, ...

This assumption is not correct. It is no problem to show related fields
in table view. Just prepare a layout based on tasks table to contain
fields from tasks _and_ projects.

Jens

--
Free PlugIn for Regular Expressions with FileMaker:
http://jensteich.de/regex-plugin/