Notes table and IndirectDataInput / Date stamp in Memo field

[Peter]

I am trying out the previous suggestions for a solution regarding time/date
stamp in a memo field. Both are very interesting.

In the case of a separate Notes Table…how do I transfer the current memo
field to the memo field record in the new Notes table? My database resides
900 records with memo fields…

Thankful for advice!

 

[Jeanette Cunningham]

You will need a foreign key in the Notes table that tells you, for every row
in the notes table, which is the row in the main table that the note belongs
to.

You need to extract both the notes and the PK of the record for each note.
Use a query to do this.
Check that query does contain all the notes together with the matching PK's,
then make it an append query and append the records to the Notes table.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Peter]

Thank you very much Jeanette, i will deep dive into the world of foreign keys
and append queries..there is much to learn here. My foreign key is based on a
autonumber formatted field..that this have any effect on this...?

Once again, Thanks!

 

[Jeanette Cunningham]

Your foreign key is the same as most other developers use for their foreign
keys .


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia