I would use a note table and then put a portal on the main layout of the notes, then when you add a new record to the portal it timestamps the note.
Here is a sample app
Thank you for this - this is a very nice little method of sorting this out!
I do however have a a question... i don't understand the function of the __fk field that's always populated with 1 in the other table where the notes and D&T stamps are going...
I'm going to have a quick go at setting this up however!
Thank you again so much for this!
The notes table is related to the main table. From the example I had one contact John Doe, and his PK is 1, so the __fk field is 1 for each record related to his record. If you add a new record to the Main table this contacts PK will be 2, so there _fk would be 2. Using this method each contact could have unlimited number of notes. All notes with a __fk of 1 would belong to John Doe. Let say that the New record you added you enter Mickey Mouse in to the Name fields, then all notes with __fk of 2 would belong to Mickey Mouse.
Thanks for that Cham,
Just a quick question, with your example you can add a new note through the portal. When I have tried to do it I can only see notes, not actually create one.
Could you please let me know how that was done.
To create a record in a portal you have to check allow creation of records in this table via this relationship. File, manage, Database, click the relationships tab. Double Click the relationship operator, then check the allow creation.
Sorry, late reply, works like a charm thanks for the help :D
hey if either of you are still around can you link me this sample? im trying to do same thing but also account name of the person who added the note.