Linking fields of a table

[Guest]

I have a Word document that is 9 pages long. The document is constructed using a table on each page. On page one there is a field in the table to enter a serial number. When the serial number is entered on page one I would like the serial number field on all other 8 pages to be automatically updated
How can I link the serial number field from page 1 to a field on each of the other 8 pages
Many thanks for your time and effort to help me
Graha

 

[Graham Mayor]

What's the relationship between the serial number on the first table and
subsequent tables?
What's the format of the serial number?
If the number is simply that - a number, and you want to increment the
number, then you could use calculated fields. Bookmark the field with the
serial number (if it is not inserted by a form field, and thus will already
have a bookmark). Then in table 2 insert a field
{={REF bookmarkname} +1}
In table 3
{={REF bookmarkname} +2}
etc.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Graham Mayor]

Plan B!
You cannot easily increment a serial number that has a combination of
letters and numbers, but I suspect you want the *same* number on each page.
That is easy to do. Either put a REF field in the page header or use a cross
reference (which amounts to the same thing) wherever you want the number
reproducing. REF fields place the content of bookmarks.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Thanks Graham. I thought it would be easy but as you've probably guessed, I'm a novice with Word. Yes, I do want the same number on each page of the report
The REF feature you refer to is also new to me but i'll investigate and see if I can do it
Graham

 

[Graham Mayor]

Thanks Graham. I thought it would be easy but as you've probably
guessed, I'm a novice with Word. Yes, I do want the same number on
each page of the report. The REF feature you refer to is also new to
me but i'll investigate and see if I can do it.
Graham

Bookmark the item (Insert > bookmark) if it is not already bookmarked by
virtue of a field.
Then at the place you want it Insert > reference > cross reference >
bookmark > pick the bookmark name,

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Thanks Graham. I did that and yes, the S/N appears when you complete the cross reference. However, what doesn't happen is that when the bookmarked SN is changed, the cross referenced fields do not automatically change to the new S/N. So, no better than manual insertion at the moment
Graham

 

[Graham Mayor]

Panic not! What you need is a simple macro attached to a toolbar button -
http://www.gmayor.com/installing_macro.htm will tell you how and provide the
code you need.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

I'm well and truly lagging behind now although macro's in excell (recorded not written) are something I am familiar with but, I have created the macro in accordance with the instructions; bookmarked the sn field; made a cross reference and then changed the sn to a new one in the bookmarked field. Then ran the macro and the crosseferenced field then displayed "Error! Reference source not found." So, progress good today but still not there - though learning. thanks for your time today and any help for the final hurdle you can give. I called my macro "Sub SN()", does it matter that I didn't use "UpdateAll"
Graham

 

[Graham Mayor]

I'm well and truly lagging behind now although macro's in excell
(recorded not written) are something I am familiar with but, I have
created the macro in accordance with the instructions; bookmarked the
sn field; made a cross reference and then changed the sn to a new one
in the bookmarked field. Then ran the macro and the crosseferenced
field then displayed "Error! Reference source not found." So,
progress good today but still not there - though learning. thanks for
your time today and any help for the final hurdle you can give. I
called my macro "Sub SN()", does it matter that I didn't use
"UpdateAll" ? Graham

The error message suggests that you have deleted the bookmark, which is all
to easy to do. It would probably be simpler to use an ask field at the start
of the document to create your bookmark and insert the result with cross
references. Updating the fields with the macro will then pop up the ask
dialog and update the ref fields. The change of macroname shouldn't affect
this, but I prefer to use names that mean something.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Maybe it was a good nights sleep but this morning I've cracked it and it works a treat. I replace the old S/N with the new S/N, click the macro you gave me and hey-presto, all fields update
Thank you for sticking with me on this. Thank you for your time and your great help
I've also found out about the Ask field which I played around with for a while and got it to work but then managed to do it without this
Thanks again
graham

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>