Global Field, passed across Tables?

[rifter1]

FMP7

I have a "worksheet" which the first thing I need to select is the City I am in. I select from a long value list the City. Done.

How do I then pass that to all the other Tables in the file?

All the other tables' "City" fields need to be set to this city. Is there an easy way to do this?

 

[JeanW]

Make sure you have a constant field in all the tables and link them together.

Put your City field, based upon this relationship on the layout.

 

[rifter1]

I know what you posted sounds simple.
(A) All the tables have a field called "City" which are linked. But the value does not automatically show up in the field.
(B) Copying the field from the original table and pasting it into other tables does nothing. The field shows up blank.
(C) Changing the "city" fields in other tables to a calculation with a relationship does not work, as I cannot match "city" to "city" and copy another field. The problem is, the "city" field in the other tables is blank.

What am I doing wrong?

 

[rifter1]

See this file.

http://members.cox.net/azcoolguy/fmp7/MJ8ae_sampler.zip

Once I set the city in the "Worksheet" tab...
I don't want to set it again. At the moment, the "windows" tab doesn't recignize it. I have to re-set it. If all the windows are deleted, the setting is lost.

Do you know how to fix this?

 

[rifter1]

ie: I want the field "City" in the "windows" tab to be non-visible. However I want it to hold the same value as whatever the user sets in the "Worksheet" tab.

 

[rifter1]

Put it this way, open the file, delete all windows, go back to the "Worksheet" tab, change cities, go back to "Windows", create new window - it has the Phoenix numbers. No matter what city you select. This is not a good thing.

 

[rifter1]

by the way the purpose of this file is to correctly size Air Conditioners for a home.

 

[JeanW]

Sorry for late reply, exams all over....

As far as I can see you're missing one Table Occurence and an open link between your Windows and Worksheet

Add a key field (auto enter constant = 1, indexed) in your Windows and Worksheet table.
Make a TO based upon this key field. (constant = constant).
In Worksheet the cityName will be the regular value, where in Windows the cityName has to be a calculated global, based upon your new TO.

That will do.

 

[rifter1]

thanks very much )