Need some ideas for synchronizing option type fields.

I use Navision 5.0 SP1.

I want to add some new fields to the Item Card with type Option on both but I want them working together.

Example if you pick Field1 - Option “A” then on Field2 - Only certain options show up from field2. ->i.e. C,D,E.

Example if you pick Field1 - Option “B” then on Field2 - Only certain options show up from field2. ->i.e. F,G,H.

Any ideas? Could the form do some of the work??

Thanks in advance,

Greg

You need a separate table(s) for this. It will be much easier to develop and support. It would work just like the Product Group and Item Category fields on the Item Card.

With Option fields you would have to put code behind it to validate the selections and you would always see every option.

I was afraid of burning another table but I guess I will.

Thanks Matt.