Recent content by rifter1

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