If I want a cell to equal the value of a cell on another sheet I use this terminology:
='Sheet3'!B1
But. Let's say the word "Sheet3" is the value of a cell, which I can change.
So in Cell A1 on Sheet 1, I can type "Sheet 3" or "Sheet 2" or whatever I want.
I want cell B2 on Sheet 1 to grab...
Attached is the problem file:
http://members.cox.net/azcoolguy/fmp7/MLM_problem.zip
What it shows:
In the layout called "Worksheet Simple"
You can select the Ceiling Type.
This drop-down list is generated from existing values in the Layout called "4A Ceilings" via a relationship.
This works...
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?
Using FMP7
I have an incredibly large table of data that I need to visually look at and select the right data to enter into field. Unfortunately there are about 25 fields that require this lookup.
This is what I want to do:
I click on the field that I want to enter data into. FMP Switches to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.