Help. Related field as a dropdown list on web.

I have a fm db with two fields color, code. This db is related to another 'all', by color. the all db has multiple records with many colors and each color contains several codes. On the original db I type a color and then the code by pull down list I want to see the desinagted code. It works on the client by relating the db using the values from field from related db.

ex.

red, 1, 4, 5

white 2, 5, 7

you select red, then values for red should be 1 4 5.

if select white then values for white.

I have multiple colors and multiple codes per color.

Help needed to accomplish this on web.

You can achieve this in one of two ways.

1. Preload all of the values into Javascript Arrays so that the dropdown changes are very fast.

2. Each time a change is made in the colour the FM database is accessed and the page/dropdown are reloaded.

Good Luck.

Garry

Hello Garry,

How can I accopmlish this with javascript. I am new.

I have two db, second db color_code contains all colors with multiple codes per color.

Colors.fp5

color

code

Color_code.fp5

color

code

Any help, is very much appreciated...

colors_code.zip

A method is described in this thread:

Conditional ValueLists

However, I think a more efficent method of using Javascript Associative Arrays exists. I will test that method when I have some time (maybe on the weekend).

All the best.

Garry