Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: Table View Data

Posted on 2008-04-14 20:04:25 by MD Websunlimited

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.

Report this message

#2: Re: Table View Data

Posted on 2008-04-14 21:28:59 by d-42

On Apr 14, 11:04 am, "Freddy" <n...@none.com> 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

Report this message

#3: Re: Table View Data

Posted on 2008-04-14 21:41:49 by Jens Teich

> 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/

Report this message