how to connect list values with data fields?

[SMcGoo]

I am not sure if I fully underdtand the query so bare with me it I sound stupid.

Do you wish all six fields to have a drop down that will make the other file fields auto enter, I think it would work like this. Create a script and enter the following, it is quite long winded but it works and I am sure that I will think of a better solution with time so please bare with me.

If(field 1 = 1)

Set Field(Field 2, 2)

Set Field(Field 3, 3)

Set Field(Field 4, 4)

Set Field(Field 5, 5)

Set Field(Field 6, 6)

else

If(field 2 = 1)

Set Field(Field 1, 2)

Set Field(Field 3, 5)

Set Field(Field 4, 6)

Set Field(Field 5, 5)

Set Field(Field 6, 6)

etc....I would create a button on the layout to perform the script but that is basicly how I would do it. This could if be a massive script if you have massive number of options though

Hope it helps

[Winddancer]

wow sounds good.

ill try it right away.

Say is "(Field 2" the name? and ", 2)" the value what it should look like?

Set Field(Field 2, 2)

ah never mind i ll test it anyway!

thx and kudos

Windey

[danjacoby]

Or you could set an auto-enter in each of the "additional fields" (you'll find it by going to Define Fields and clicking the "Options" button).

The drawback is that, if you change the value in the main field, the other fields won't necessarily change. A possible solution is to make the other fields Calculation fields.

[Winddancer]

Hi all,

this is my first visit to this forum and I haven't used Filemaker all too long. So I hope you bear with me while I am asking some "dumb" questions!

I have a Filemaker document, which contains a list with several values (drop down) and 6 additional data fields (marked as number containing data fields).

The problem is quite simple: How do I assign a list from the drop down value in a way that if I choose one value from the drop down menu, the 6 additional fields are filled with predefined values?

Is that a dumb question? Well I think so. I also don't know if this is the right forum.... bear with me!

kind regards

Windey

[SMcGoo]

Field 1 is the name of the field and the number beside it is what you wish to set the field to.

I would agree with danjacoby that creating field will ensure the data is updated correctly but this will only work if you do not wish to enter a value into field 2 and have the other five fields update.

If field 1 is the only field that you will be entering data into the other fields could be a calculation. If this is what you want to do I could write a basic field defination that you could would be able to use. Email me if this is the case on [email protected]