One to many relationship
Background Info: I am using the following
- Filemaker pro Advanced 11
- Mac OS X 10.6.6
- Single user mode
- I have been using Filemaker Pro for a few months
I have two tables. One which contains a master list of stocks with a primary key of __kp_SEDOL and the other which contains the fields _kf_SEDOL and the next reporting date for that company and the date that the record was updated. This table is updated monthly with new records.
I have created a relationship between the tables based upon the SEDOL common field. However, when I create a layout from the master list table why can't I see any data for the reporting date field of the other table. It is just blank!