Keeping Client Separate in a database
May seem like a simple question, but I have created a database using Filemaker Pro V12. I am using it as Media Planner. Issue I need to solve is our different clients that would be input into this database may have several campaign running at the same time. So when I create insertion orders and select the client I would like the campaign field to populate with only those campaign associated to that client. Right now I get all campaigns blended to together.
I have a separate table for Client and campaigns (together) so I thought this woudl occur on it own. Any ideas how to correct?