Jump to content

Finding/Sorting w/in Portals


ryan93

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

Recommended Posts

I have created and inventory tracking database. Within the database I have a few portals. I would like to do finds on portal rows. Basically what's going on is that I have a database of "inventory transactions." The portals are taking information from that database. I want to omit all the portal rows from a layout that doesn't have a purchase order number, po number is a field in the portal row. By doing this I can create a receiving layout that lists all the open and closed PO's by part number. If anybody knows anything about finding records within portal rows please help. Any information would be helpful.

Thanks in Advance...

Seeking Solutions

Link to comment
Share on other sites

quote:

Originally posted by ryan93:

I have created and inventory tracking database. Within the database I have a few portals. I would like to do finds on portal rows. Basically what's going on is that I have a database of "inventory transactions." The portals are taking information from that database. I want to omit all the portal rows from a layout that doesn't have a purchase order number, po number is a field in the portal row. By doing this I can create a receiving layout that lists all the open and closed PO's by part number. If anybody knows anything about finding records within portal rows please help. Any information would be helpful.

Thanks in Advance...

Seeking Solutions

You need to better define your relationships to display the right information in the portals.

You can perform find in the related fields in a portal, but it functions the same as any find within the file and will not restrict the data shown in the portals at all.

I suggest using calculated keys in your databases that are only valid if the particular criteria is met.

For instance cInvTrackID = If ( IsEmpty (PO Number), "", InventoryTrackingID )

Then you have a relationship between Inventory Tracking and Inventory Transactions like so InvTrackID = cInvTrackID.

Then you will only get records in the portal which have a PO Number.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

This topic is 8790 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.