Search results for query: *

oooooooooooooooo! THANK you!

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...

Maybe it's a PC thing, are you on a Mac?

yes it's empty, untilI select it, and the drop-down list appears, populated with the OLD values, (incorrect ones). At least, it's doing this on my laptop. Ok let me ask this: is there a way that, once you select a value in a field you can force it to be de-selected?

Here is what I mean by the "simple" form... http://members.cox.net/azcoolguy/fmp7/form1.jpg Not much user input is required. And eventually, I will have this usable on a handheld.

(A) Select a "Type" (B) cursor jumps, select a "Insulation" (C) DO NOT DESELECT THE FIELD (D) Change the selection in "Type" (the first column) again (E) Insulation list will NOT update. Regarding the (a) (b) (c) There will be 2 versions of this load calculation program. One will be the...

Oh and I did promise this, the full relation tree -- I did some thinking about it last night, it's only about 1/3 of what it will eventually look like. http://members.cox.net/azcoolguy/fmp7/PARTIAL_RELATIONS.jpg

Oops, link for above post: http://members.cox.net/azcoolguy/fmp7/MJ8ae-C_demo.zip

THANKS so much for your help! IT WORKS. But now that created another problem: The second value list does not refresh automatically. I have to "click off" all fields if I go back to the first list and make any changes. Otherwise the second list will not refresh. Open the file you will see what...

...ok well between my 2-year old, my wife, and trying to find time to work on this, and my regular job -- It's well after midnight, and I still haven't figured out what I'm missing... will try more tomorrow...

...still working on it...

Also keep in mind this is still my first database, thanks for the tips, I'm still learning as I go here.

Thanks very much, I'm on a call atm, but when I get home I'll take a look at this. Ya ... about rearranging the relationships... I'll tell you what, later on I'll post the relationships as they looked BEFORE I cut them down -- trust me, I am only about half done with the links. They are...

P.S. the relationships that apply are in PINK dialogs, All the other ones are not important. All the variables related to ceilings start with the word "Ceiling". Sorry for the mess, deleted 95% of all the tables and relationships to make it easy to see.

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...

thanks very much )

by the way the purpose of this file is to correctly size air conditioners or heaters for a home. The data included is extremely limited, so I'm not worried about the file link )

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

So how do I make the value "City" exist across all tables? Once selected in one table?

The first question was... given the complexity of the tables, couldn't I have a large, single-page layout showing all values in a human-readable grid. Which. When I click on the field that I want the "heat transfer measurement" to be put into... it pops open that Large Grid... perhaps if you...