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.