Drop down menu to show only related project contacts

Thanks Mark!

I did actually look at that but I can't seem to find the appropriate fields to select.. I assume it should be the ID (key) in project table, should match the Related Project (ID) in contacts table. I'm not sure why it's not selectable on the conditional options.

Playing around I was able to use a different field (project description which is a lookup on the contact table that comes from the project table) but when that field is set to read-only on the closeout form (they shouldn't edit it from there) the contact drop down is disabled and says to first select the project description. If I make the description field editable on the closeout form then the drop down menu then populates with the right list. As a workaround I just used a dynamic rule to make it read only and that works.

But what ID or field should I really be selecting. Record ID# (from the Project table) is not listed in the choices in the first condition. I would think I want it to match the "Related Project" in the Contacts table.

Anyway, still confused but I think I at least have a workaround using a different field. But let me know if you have any ideas or insight.

Thanks again! :)

------------------------------
David Hoover
------------------------------