Majid said:
Hello John, Thank you for yor advice, it is very true.
I have one master file with several view tables, each view table has their
own custom field columns ( flag 1,2,3,4,5) each flag column represents one
key item for i.e contract staus and wethear is signed or not so team will
change NO to YES.
every view table shows summary task plus custom fields that needs to be
filed in by each team member.
What I want to do for the team member is that to complete the cell that
aligned with the summary task only, for exapmlle to change NO to YES and team
do not have to change the NO to YES for every tasks. What we do now is that
we enter the info. on the summary task row only and delete the defult NO
manually.
I hope I explained well
Thanks again Jhon for you effort to help me out on this.
Majid,
Assuming I understand what you want, I have a real simple solution. If
all you want is a "yes" or "no" indication at a summary line, use spare
text fields (e.g. Text1, Text2, etc.) instead of flag fields. Also, do
not use a custom field with a value list. There are only two possible
responses so a value list doesn't really offer that much convenience. It
is not that difficult to enter a "yes" or "no". Don't tell me your guys
are that lazy. And by using spare text fields instead of spare flag
fields, the only entry will be at the summary line.
If for some reason I have misunderstood what you want or my simple
solution is just not elegant enough there is a more complex solution. An
event based macro could be developed that will trigger on the entry at
the summary line and change the values for all task lines below it.
If you reply, start a new thread. The number of posts in this newsgroup
has exceeded my preferred setting for this newsgroup (i.e. 100 messages)
and I generally only check old messages if I see an indicator that I
have responded.
Hope this helps.
John
Project MVP
