Jump to content

Limiting Portal Results


This topic is 6672 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm working on a database to keep track of ads for a publication. I want to show the ads that each advertiser has posted in a portal on the advertiser's page. There are tables for advertisers, ads and issues. I've attached a bare bones sample. But what I want is to have the ads that show up on the advertiser's page limited by a selection menu for the date of the issue they placed ads in. It's something I've done before with another database, and I just can't figure out why it won't work here.

The advertiser Copy Layout is the one that should work with the selection menu. The plain advertiser layout should show all of the associated ads in the portal.

Any help is greatly appreciated.


Link to comment
Share on other sites

As Slobey so eloquently pointed out, your match field can't be unstored, meaning it can't reference globals or related fields. One way to deal with this that should work for the example you posted, is to use lookups to pull the information from its source table, and use the resulting stored data for the match key.

I have taken your sample and added a couple lookup fields that demonstrate this. Note that if you needed to change an Issue Month/Year after the ad records have been created, you would need to perform a Relookup on the ad::IssueID, though this doesn't seem like something you would need for this application.


Link to comment
Share on other sites

This topic is 6672 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.