Store text from dropdown/popup box and two boxes are related

[Haseeb]

Hi

I have following tables

Job Profile: ID, Designation, Branch[Text],Division[Text]...;

Division: _kp_DivisionID, DivisionName;

Branch: _kp_BranchID, BranchName, _kf_DivisionID.

Division & Branch are related.

Now I am trying to create two Drop Down/Popup text fields Division & Branch.

Want to select Division and store the Division.DivisionName in "Job Profile".Branch field. So that it remains historical. Then want to select Branch.BranchName filtered by selected Division and store same way in Branch.

So to achive that what I should do?

Thanks in advance.

Haseeb

[bcooney]

This is called a conditional value list.

In Job Profile, you should store a BranchID and DivisionID, not their text values.

CondValueList.fp7_2.zip

[Haseeb]

Thanks for your solution.

Problem is keeping track of BranchName and DivisionName. Cause from time to time, these names changes when ever merge/de-merge/restructure occurs. And Job Profile record is unique for that instance and its historical.

I may need to think in different way. May implement some text fields to preserve these names.

Regards

Haseeb