I am new to FMP so please pardon me if this question is "easy". I am
using FP8.0 and am trying to make a drop down menu that references a
table in my data base, ie rather than mking the drop down menu source
a value list I wanted it to reference a field in another table of the
database. I have made the relationship in the "define database"
window and in the "layout" it has a drop down arrow icon, but nothing
shows in the drop down menu. If I look at the Field/Control setup
window I have it set to display data from my table, but nothing shows
in my dropdown. I do have hte box marked autocomplete using value
list.

What have I not done?

Thanks in advance...

Faustish

Just a thought:

You've defined a relationship, but are there actually related records?

If there are no records in the related table that satisfy the relationship criteria, then nothing will be displayed.

Matt

On 03/08/2007 11:41:51 "faustish" <faustish (AT) aol (DOT) com> wrote:

To create a drop down menu you have to have a value-list. This has to be
created seperate. You find it under menu, File > Define > Value Lists
The Define Value Lists for "MyFileName" window appears. Click NEW.
The "Edit Value List" appears. Give the list a name.
Select the radio button "use values from field".
The "Specify Fields for Value List "MyList""window appears.
Under "use values from first field" select the table reference (the related
table or just a complete table with values) from the drop-down menu.
And select the field form which you want the values to appear on your layout
later.
(For now leave the second column empty)
Click OK three times
Now go to the layout where your menu is going
Put the field on your layout.
Double click it, the "Field/Control Setup" window appears
Under Control Style you see an item "Display as"
Select "Pop-up Menu" and under that select from "Display values from:" the
"MyList"value-list

Now you are ready to go

Keep well, Ursus

"faustish" <faustish (AT) aol (DOT) com> schreef in bericht
news:1173372111.215658.83100 (AT) q40g2000cwq (DOT) googlegroups.com...

On Mar 8, 3:48 pm, Matt Wills <I... (AT) witz (DOT) end> wrote:

I am not sure I understand you. I did make the relationship and there
are records in the table - I don't understand how to satisfy the
relationsip criteria beyond "its in the table".

Thanks,

Dawn (Faustish)

On Mar 9, 4:45 am, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:

When I do what you suggest, and return to the browse layout format,
viewed as a table, I can "see"that it is a pop up, but when I click on
that box, I see nothing. If you look at the header for that table
column it appears as Baker::BakerA. These are the 2 things I have
made relationships between in the define database relationship table.
WHat am I missing?

Thanks,
Dawn

This way you only see items that are valid through the current relationship.
This forms a dynamic Valuie List. the contents changes when the relation
changes. If there is no valid value in the relation, the Value List remains
empty. This is what you are seeing now. If your email address is valid you
will receive a small example I have rigged to show you how it is set up
properly

Keep well, Ursus

"faustish" <faustish (AT) aol (DOT) com> schreef in bericht
news:1173454974.392242.52350 (AT) j27g2000cwj (DOT) googlegroups.com...

On 03/09/2007 10:32:41 "faustish" <faustish (AT) aol (DOT) com> wrote:

The very basis of a relational database:

Having records in each table means nothing. The records have to meet the criteria defining the relationship.

In FileMaker, the default relationship is that the Key field in Table A EQUALS the Key field in Table B. You can also make it NOT EQUAL, GREATER THAN, LESS THAN, etc., but for demonstration purposes, let's say that if A:Key = 1 and B:Key = 1, then there is a relationship. If B:Key = 2, there isn't.

Defining a Value List based on a field a related table requires that there be related records. Otherwise, there is nothing to display.

To make matters more confusing, you can define a relationship in which ALL records in one table are related to ALL records in the other table, whether the Keys are equal or not (there is a real, official name for that type of relationship, but it escapes me for the moment).

Matt

On 03/09/2007 17:27:47 Matt Wills <I'm (AT) witz (DOT) end> wrote:

For whatever reason, the name just came to me out of the blue.

It's called CARTESIAN.

Matt