Here’s a hypothetical scenario that describes what I’m trying to do. Let’s say I have a table that has two fields: author name and genre. I have a second table that tracks books and their genres. I would like to create a dropdown field to select an author name but I only want to see the author names that are in the genre specified in that specific row. Is it possible to use a field in one table to match up and limit the view of the dropdown values from another table?
Sorry if this is confusing.