Jump to content

how to connect list values with data fields?


SMcGoo

This topic is 8210 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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! wink.gif" border="0

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! wink.gif" border="0

kind regards

Windey

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

This topic is 8210 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.