newbee help

[C.I.D.E.R]

I am very new to FM9. I would like to display on a main page all the records from a table called jobsheets. I thik I need to use a portal but on trying it as not worked. I just get a blank table. Can anyone help me out please or point me in the right direction.

[Fenton]

You would need a relationship from your "main page" table (whatever that is, Employees?) to the jobsheets table. It would have to based on fields which contained the same value in both tables (for a simple relationship; there are others); such as (Employees) EmployeeID=::EmployeeID (in JobSheets).

This is done on the Relationship Graph. Without the correct structure on the Relationship Graph, there is not much that can be done.

[C.I.D.E.R]

I have tried copying the jobsheets table. Then I renamed it as Bodyshop Main.

I created a link bet the two job IDs and then put a portal onto the layout to show the records from jobsheets. Its still didnt work.

Its ok I have been an idiot.. I didnt have the data in one of the tables so the portal wouldnt display the record because technically it didnt exist.. Thatnks for your help though

Edited April 6, 2008 by Guest