Jump to content
tapper46

Record missing from portal

Recommended Posts

tapper46

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
tapper46

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



×