auto creation of a series of fields

[Aussie John]

I have created an on/off timer which calculates the length of the session. It also adds the session to give me a total.

I would like to record each individual session against a date to create a log. This means I need to create a new field each time i have finished a session.

Is this possible? or is there a better way.

I have a separate related DB to record this in.

Thanks kindly

[Aussie John]

been thinking about it a bit more and maybe is best to use subsummaries and instead of new fields create a new record.

Trouble is I then cant get the new record to automatically insert the unique number for the relationship. I want this summary file to be transparent and all entries be automatic.

Think I am in a mess, just not even sure how to structure this.

[CobaltSky]

If you turn on the "Allow creation of related records' option for your relationship to the file in which the start and stop times are recorded, the records will be able to be entered into a portal in your main file.

With this approach, each new record - created by simply entering details in the last row of the portal (which is kept blank for the purpose by FM) - will automatically acquire the key field to tie it back to the current record in your master file.

You will then be able to use aggregate functions in unstored calculations (eg Sum( ) and Count( ) etc) to provide dynamic dislpays of overviews of the data across all related records.

[Aussie John]

Thanks - think I will need to read up about Portals as i have never really understood them.