Ok, I am a novice at this but I am trying.... This is what I am trying to do.

I have a field (field 1) with a dropdown list of items, lets say Cars. I want field 2 to list the prices of those cars when I pick it from field 1.

Basically, if you pick Ford Focus from field 1, field 2 would show $21,032. Also, field 2 should be editable.

Thanks guys !

JT

Edited January 15, 200719 yr by Guest

Hi

which are your tables ?

Or do you have only one ?

Im not sure I understand? One table.

JT

Welcome! No need to apologize for being a novice, we're all here to learn.

What you need is a relationship between field 1 and the field that stores the same value in the table where you have the prices. Once you have that set up, you need to configure field 2 to be a lookup or an auto-enter calculation of the price field across that relationship.

When you do that this is what happens:

- you enter something in field 1 (picked from the value list)

- this establishes a valid link across the relationship

- FM takes the price field data from the match and puts it in field 2

OK, so...

A lookup or an auto-enter calculation.

I'll go play with that.....

THANKS !!

JT

What I do is have three fields Car, value and a globalCarToSee

Make a relationship betweeen the global and the car . Use the global to apply the value list to and then you can use that as the "selector" field.

The global and car be in the same table but I find it better to have a special table just for the global field. That way your layout doesn have to have any records in it.

TIP: make the value list for the global to be the records of the car field

Edited January 26, 200719 yr by Guest