Row size in Table View

[sdutton]

That's it. Now I'm a bit embarrassed--I'm new to FM and working with databases--could you explain to me what exactly I need to do to bring this over to my FM database. I'm assuming I need to define a field like you've done (color alternate) and copy the calculation. But what else need to be done? How does this color alternation get "activated?"

[comment]

Just make sure the calculation is unstored. It is "activated" by the position of the record in the found set (i.e. Get (RecordNumber) ), which Filemaker revaluates every time the widow is refreshed.

[LaRetta]

Just for the record, I get the same results Comment got - with text disappearing (I'm using Dev7) and it threw me - missing function! Changing the actual text color is not good practice. Re-sorting, performing a new search - just about EVERYTHING one would do to the actual records - would mess up the 'alternate' display. And as the number of records grows, it would take longer and longer. Imagine having to run a removal script through 480,000 lineitems.

"BTW nobody asked you to come on this topic... but you did and criticized (7th post of this topic)"

This statement was most certainly out of line, Daniele. Comment wasn't at all rude to you in the '7th post.' Everyone has a right to respond to someone who posts. And if someone gives poor advice, we have an obligation to mention it. Just because one person responds first - doesn't give them exclusive rights. We ALL contribute here. And Comment is right ... we should all CARE that our suggestion makes sense and doesn't make a situation worse. Colored text would CERTAINLY cause many problems.

BTW, if this business were now to try to print their list of records, not only would the records be scrambled and no longer alternate (if they sorted or re-searched or deleted any); but it would also display differently on the printed copy (the blue text would be slightly lighter in color when printed B&W). They would then be spending their time looping through ALL records and reformatting them again and removing your process from their file.

LaRetta

[sdutton]

I've created a calculation field, copied your calculation, changed the three field names from "first, last, and company" to my three names, checked "do not store", but nothing happens. The records in my list are still all black. What am I doing wrong?

[Lee Smith]

I didn't see where you said that you created a "List View".

Lee

[comment]

Hard to say from here. Did you put the calculation field on the list layout?

[sdutton]

Success!!! Thank you very much for helping me set this up. It's working exactly like I had hoped it would. I really appreciate the fact that you kept up the assistance until I finally "got it."