Notes (text) field show most recent. 
Author Message
 Notes (text) field show most recent.
We want to have a notes field (text) that we enter information on a person
in. It would be nice if this field always showed the latest text. Also, is
there a way to get the whole text field to print when printing out a record?

Thanks for any suggestions.
--
Kevin Bacon



Fri, 27 Sep 2002 03:00:00 GMT
 Notes (text) field show most recent.

You don't say wether those notes are in a related database or are just a single
field in the main database.  

If they are in a related database and you are using 4.0 or higher you can use
portal sorting. (I actually don't know how to do this, but somene else on the
list can.)  What I can add to this is in my simple task list db my portal has
an auto generated time and date fields which keeps track of when I made the
note of the task to be done.  You could then do the sorting on the date and
time.

If it is a field in you main database, then you need to create a global field
and and a field to put your new notes into.  Write a script to cut and paste
the contents of your main notes field to the global.  Next, paste littera a
couple of hard returns into the notes file and then cut and paste the contents
of your new notes into the main notes file and then cut and paste the original
notes back to the main notes file.

Good luck

Steven Scharf
SCS Media Services
57 East 11th Street, 9th Floor
New York, New York 10003
212-822-8555


We want to have a notes field (text) that we enter information on a person in.
It would be nice if this field always showed the latest text. Also, is there a
way to get the whole text field to print when printing out a record?

Thanks for any suggestions.
--
Kevin Bacon



Sat, 28 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Webpage won't show text field but will show calc of text field

2. 1 big notes field vs. related notes file

3. Text Field not showing data

4. text box showing database field

5. Access 97 text fields are not showing up in database

6. Problem with updating from TEXT field into TEXT field

7. SQL Query problem concat text field from mulitple rows into one text field

8. Text Field -> Repeating Calculation (Text) Field

9. Select distinct for certain fields but show all fields

10. Filemaker field problem - most recent date

11. Loading notes truncates to 16 char Memo/text with DTS

12. loading a 400K text file into a text field in SQL


 
Powered by phpBB® Forum Software