Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise


Record missing from portal

Recommended Posts


I have two tables:

PurchaseOrders and PartsRequired

They are joined as follows:

PurchaseOrders::SupplierCode = PartsRequired::SupplierCode and

PurchaseOrders::RRNo = PartsRequired::RRNo

The PurchaseOrders layout contains a portal to display the records in the PartsRequired table meeting the criteria of the above join.

If a purchase order meeting the above criteria doesn't exist, a script creates one when triggered to by entering the SupplierCode into the appropriate field in the PartsRequired layout. This works perfectly.

If I then add a new record into the PartsRequired layout meeting the above criteria it doesn't appear in the portal. If however I enter layout mode on the PurchaseOrders layout and re position the fields in the portal, then return to browse mode, the record appears.

If I then add more records to the PartsRequired layout they all appear in the portal.

I don't understand why I need to change the portal design in order for it to work properly.

Share this post

Link to post
Share on other sites

I think I have found the problem. The positioning of fields within portals is so sensitive. So frustrating!!!

Share this post

Link to post
Share on other sites

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


Important Information

Terms of Use