history about records

[effa]

I have a db with many records about available cars. Now I need to add history records to each record in db (I feel it may be like creating different table for each initial record).

So, I want to have a "history" button and it should open a new layout with a new table (for each record in initial db) and 2 fields: date, comment.

Is it possible to create a new table for each record via script? (is it necessary to do so?)

[JerrySalem]

I am not exactly sure what you are trying to accomplish.

You probably don't need a different table for each record.  How about a single table, with 4 fields; Date, Comment, FieldName, Field Value.

 

Before starting, I would look at UltraLog. (http://www.nightwing.com.au/FileMaker/demosX/demoX01.html)

This might do what you want with much less overhead.

 

Jerry

[Rick Whitelaw]

Never set up a situation where new tables need to be created forever. Use related records. A database should be set up to "run by itself". In other words a user should be able to use it without ever "going under the hood".

[LaRetta]

Hi Effa,

 

It sounds like what you really want is a Notes or Comments table where you can track many comments by date against a single parent ( car ) record.  Is this correct?    If so, you do not need to create a history record ahead of time but rather you create the history record when you are ready to enter something into it.  And you create that history record in a single new table.

 

If this is correct, there are two methods:  1) Allow Creation and 2) via script. We can explain either or both methods if this is what you want to do.