AnsweredAssumed Answered

Calculated Value Lists

Question asked by kennyferg on Mar 5, 2014
Latest reply on Mar 8, 2014 by kennyferg


Calculated Value Lists


     Apologies if this has already been answered - I've gone through the posts but I can't find something that fits exactly what I have - at least doesn't seem to fit.

     I have a database with several tables but the following tables are the ones I'm interested in: "Publications" and "Adverts" which are linked with a relationship.

     The publication table has a text field named "PublicationID"  which is the name of the publication and a "Status" field which contains either "Active" or "Complete". In the Adverts table, I am using a drop down list which I need to display ONLY the PublicationID's which have a status of "Active". At the moment, the dropdown lists ALL PublicationID's irrespective of publication status and it's causing me a real headache.

     Any help at all would be hugely appreciated.