Newbies Philip nyc Posted November 17, 2008 Newbies Posted November 17, 2008 Hello, I have a parent table (students) with a portal that displays records from the related table (courses). There is a portal on the Students layout that is based on two criteria: 1) (the very common) foreign key to primary key AND 2) a global field in the Students table that allows the user to see only filter to display only records that are type "A" or type "B". This works just fine and the filtering works as expected in the portal. However, when the user sets that global field to set the relationship to show only one type of record (e.g. type "B") and then does a search it returns a found set that includes Students with only type "A" records, and the portal is empty (which it should be). I don't want the search to return students with empty portals. Does the filter not work in find mode? Any insights are appreciated. Thanks so much!
IdealData Posted November 17, 2008 Posted November 17, 2008 The problem is the global field, which cannot be set during the find procedure. How about scripting it so the user can specify "A" or "B" (in a dialog box) immediately after the find has performed.
Newbies Philip nyc Posted November 17, 2008 Author Newbies Posted November 17, 2008 Okay, good that it's comfirmed that globals dont work in find mode. Thanks! What would happen after the user selects A or B? In other words, what comes after the If Get(LastMessageChoice) script step? Thanks for your help!
Recommended Posts
This topic is 5849 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now