Forum Discussion

LijaHarris's avatar
LijaHarris
Qrew Cadet
6 months ago

Conditional Drop Down of Child Records based on Dates

Hi, I am not sure on how to accomplish this and I am very open to out of the box ideas.   I have a parent table called measures that has a start and end date for that measure.  I have a child table...
Conditional-Dropdown
DonLarson's avatar
DonLarson
Qrew Elite
6 months ago

Lija,

You described this:

So if you have a Project, when you edit it and change the Related Measure field, you want to see Start Date End Date   to be able to relate the tables.

The way I would do this is to make a report in the Measures Table called Record Picker Projects.   I would put only those two fields in the report and sort it high to low by Start Date.

 

In the form in the Projects table, set that report to be used for Data Entry