I am trying to build a small FileMaker workflow solution. (FSA 7 /win 2003srv , FMP, Win 2000 & XP station)

This solutions involves a main PICTURE Table with a certain number of Picture Container fields (Picture_N) and corresponding Picture Identifier fields - Picture_N_ID numeric indexed field .

Users will annotate different text comments about each picture on the record . The comment history is important and need to be stored, including time, author etc.

To hold this comments I set up a related COMMENT table. Each new comment, generates a new record on this table, with corresponding comment_text field., comment_time, comment_date & comment_author field

Relationship for each container field is based on corresponding Picture_N_ID field on PICTURE table AND comment_ID field on COMMENT table.

To write a comment, the user activates a Button, that bring him to a new Window using Layout corresponding to the COMMENT Table.

PROBLEM : When writing comments (on the

I think the relationship should be based upon Picture_N_ID only. No need to make it based on commen_ID and as you will have many comments for each picture, each with a different CommentID, I wonder if this is the cause of the freeze. Additionally, if you set this relationship to be allowed to create new records in the comments table, you can create a portal on a layout in the Picture table with this relationship, place Comments field in the portal, and your users can make as many comment records without going to another table.

Thanks dkemme for your very fast response.

Each relationships, ( 1 for each picture field) is based only on one field on each table: Picture_N_ID is the field on thePICTURE table; Comment_ID is the name of the key field on the COMMENT table.

The PICTURE table have 20 Picture containers (and 20 picture_ID fields), on each record. Each picture has its own comment history, including time, author etc. Unfortunately there is no Space dor the comment history.

Thanks