Filemaker Freeze writing on related text field

[new2fm]

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

[dkemme]

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.

[new2fm]

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