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
****tal.
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 ****tal,
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
Relation****ps graph and it didn't seem to work correctly.
Any assistance is appreciated.
|
