Dear FileMaker Guru:

I was asked to revise a FileMaker v.6 Report Tracking DB, hosted on v.5.5 Server.

On the "Entry" Layout, users can enter "projected" total page number to the "Page Count" Field. The value will be replicated to the "TotalPageNo" Field in the "Tracking" Layout, where all sorts of information of the report are monitored.

Now, I have received a request: Create a new "Finalized Page Count" Field for the manager, only, to enter the "Finalized" total page number into.

If the "Finalized Page Count" Field is empty, current replication stays. If the manager enters, in this field, an "final" number, which will updates and locks, beyond modification, the "TotalPageNo" Field in the "Tracking" Layout.

Help, please! How to utilize "If""IsEmpty""IsValid" Logical Functions to implement the new replication?

regards,

Max NY

Put all the field names into a calc'field containing this equation Count(field1;field2;field3;field4)=4 as number ...if say the record holds 4 fields, then make a summaryfield summing this calcfield's result which is either 0 or 1. Where all the the completed records obviously shows 1 in the logical statement.

Since your profile exhibits access to fm7, could you investigate this template - and then transfere the approach to the fm6 solution.

--sd

voidance.zip

Dear SD:

I have not quiet understood the correlations between my asking about The Logical Function""IsEmpty"" and your "Voidance." Please elaborate!

Thanks!

Max NY

Perhaps I havn't understood your question right? I admittingly grasped for a straw in it! Explain a little more of what you wish to achieve. That is rephrase it sligthly....

--sd

I don't understand the question either - especially the "replication" thing.

Are you saying that if the FinalizedPageCount field has no value populated in it by the manager that further modification of the TotalPageCount is allowed, but when the manager enters a final page count into the FinalizedPageCount field that nobody can be allowed to further modify the other fields?

I think it's a calculated field validation that you are looking for? So that when someone tries to enter a new record after the 'Finalized' field is populated the system prompts an error... Am I close??

Dear SD:

Thanks for your reply! It is a v.6 DB.

I talked about "replication." I meant: On the "Entry" Layout, users can enter "estimated" total page number to the "Page Count" Field. The value will be propagated to the "TotalPageNo" Field in the "Tracking" Layout, where all sorts of information and progress of the report are monitored.

You are right=>=>

"I think it's a calculated field validation that you are looking for? So that when someone tries to enter a new record after the 'Finalized' field is populated the system prompts an error... Am I close??

"

Thanks!

Max NY

I am afraid it still doesn't make sense to me. Is this in the same file? If yes, what's the point in "replicating/propagating" data from one field to another? Couldn't you just put the same field on both layouts?

Here's an idea: two fields, Value and Status. User enters a value and selects a status of "Estimate". Another user changes the value, and switches the status to "Final".

I'm still trying - perhaps this way:

http://www.filemakerpros.com/LOKFIELD.zip

--sd

Dear Veteran:

The “Entry” Layout is for data entry. The “Tracking” Layout is geared toward offering a quick glance at all of the aspects of the status and progress of the project: more like for display and read only.

Thanks!

Max NY

That's a great tip! I never thought of using current time to validate a field and prevent mod.. I'll definately be using using that one.. thanks!

Dear Newbie: what you have there is a non sequitur. You can have as many layouts as you want, and they can all use the same fields. There's no need to "replicate" or "propagate" data into another field, just because you want to put it on another layout.

Dear SD:

I do appreciate you effort!

regards,

Max NY

Is this an invitation to give it yet another stab, since I havn't been hitting particular well - or??

--sd

Dear SD:

You are great! Your formula works on v.7 or higher!

Not on v.6 or older!

Awesome!

Max NY

Dear SD:

You are great!

Let's not get carried away here! :)