This is not a bug, but how is the best way to handle? The situation:

say a company file has the usual, company name, address, etc.

Another file of say orders, has a real field for company key, and a symbolic for the company name. Now, we index the symbolic company name. We can now lookup an order by company name…so far, so good.

Now, if the company name is changed on the company file, the orders file does not "know" about it, thus no index transaction is created to reflect the new name, so the index lookup now fails even though the name (new one) displays correctly in the xlated field.

What is the best solution…someone else has had to have solved this?

I'm guessing that I've got to detect the name change in the company file and create the appropriate transactions for all the orders records that belong to this company and stuff the transactions in the! file and then process the transactions (update the indexes) Any other suggestions? arcs@arcscustomsoftware.com

ARCS, Inc. [img]http://www.arcscustomsoftware.com/arcslogo.gif[/img] </QUOTE> ---- === At 15 MAY 2000 05:02PM WinWin/Revelation Technical Support wrote: === <QUOTE>Paxton- On the Write event on the Company Window, you could: do a forward event to save the record do a btree.extract on all orders with that company id, read the records, blank out the company id write the record put the company id back in write the record again. Brute force, but it will cause the index to recalculate with the new symbolic. Hope it helps- Mike Ruane </QUOTE> ---- === At 15 MAY 2000 05:44PM Paxton Scott wrote: === <QUOTE>Thanks Mike, easier to do than my solution...though maybe not as fast. I'll try it. </QUOTE> ---- === At 17 MAY 2000 10:30PM Richard Bright wrote: === <QUOTE>The more elegant way, (but with some potential downside because it applies a modified filing system to the table) is to mark the dependancy on the symbolic Dict field. Edit the symbolic in field 21 (depends on field) and define this item as related to the table and column for which a dependency exists using form TARGETTABLE*TARGETCOLUMN. Note that field 21 can be multivalued to establish multiple dependancies. For more info see REVMEDIA vol 2 issue 4 p5 /6 (Purchased from SPREZZATURA) Regards Richard Bright </QUOTE> ---- === At 18 MAY 2000 07:30AM [url=http://www.sprezzatura.com]The Sprezzatura Group wrote: ===

[notag]And the good news is…. http://www.sprezzatura.com/V2I4A3.HTM

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>] [/notag] </QUOTE> View this thread on the Works forum...