Dummy Variables in browse screens?

Scott Nelson scott at logicdatasystems.com
Thu Mar 17 11:23:35 PST 2005


Tim Fischer wrote:

>I'm beating my head against a wall on this one.  Maybe someone can help me?
>
>First off, I'm running FP 5.0.13 on Solaris 9.
>
>I'm trying to organize a lot of data to make things cleaner and faster.
>This is a file of trucking companies throughout the US, Canada and Mexico.
>To take into account situations where 1 company has multiple offices, I've
>created a Terminal File and a Corporate Office file.  All contacts are
>stored in a "contacts" file and all addresses (3 per terminal) are stored in
>an "address" file.  This is to make change easy - if I need to change an
>address that is duplicated in several places, I make one change to the
>address file and it's all done.  The idea is to not duplicate data to keep
>everything clean.
>
>The problem is, if I need to go into the Corporate Office file, sorted by
>"state".  I've figured out how to do that (basically by rclerking into the
>address file and using a lot of dummy variables on screen) but I'm needing
>to put some of the data from the Corporate Office file into the browse
>screen.  Is this possible?  I'd really prefer not to duplicate data, but it
>looks like I'm going to have to...
>
>Tim Fischer
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
> 
>
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>  
>

in your browse lookup, you have a selection for Processing Label
put a label name there, and below, use the label to define a processing
section to do the lookup into the other file using a variable filled from
your browse lookup file.  then assign a variable to the data required and
place it on the browse lookup instead of a real fld.
be sure to blank the variable if the record you are looking for
is not found, or the browse may show the data from the line above.

hope that helps, and my description is ok.

if you need more info, connect to the fproom and we can talk about it live.

Scott Nelson




More information about the Filepro-list mailing list