Dereferenced column disappears from the form

[998drmohit]

Sir

    This is my first post here and I would like to congratulate the team for such an empowering product. I just stumbled upon the solution a few days ago and I have been totally consumed since then. At my workplace we are trying to build an inventory management app. we have three tables to link

1 ItemDetails- drug name and details. Primary key- "Code"

2 Batch Details- Many drugs have more than one batches, this table contains details like pack size and qty

3 CodeBatchRack- Many batches have to be kept at different locations. this table keeps record of each location of the batch.

We are trying to build a form for data entry in CodeBatchRack table. What I wish is a dropdown of batches when the user selects the code in first entry. I have tried valid_if, enumlist and dereference, the problem we are facing is as soon as the dereference formula is applied the batchno field disappears from the form instead of giving a dropdown. Please help!

[graham_howe]

It sounds like you want dependent dropdowns:

Take a look at the following article in the help documentation.

	Dependent Dropdown
	How to make a dropdown with choices that depend on the value selected in another dropdown.