Jump to content

Lookups in numeric portal fields missbehaving


charper
 Share

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

Recommended Posts

I have Order records, Item records, and Product records stored in one flat file. I have a layout for displaying information about Order records only. It has a portal on it that displays the line items (Item records) for a given order. The portal displays an Item ID field which has a popup list that lets the user select from a list of Product IDs. When a user selects a Product ID it gets placed in the active Item ID field in the portal, no problem.

Now, I have several other Item fields displayed in my portal along side the Item ID field. Some of these other Item fields are text fields and some are numeric. They get their values by LOOKUPS via the Item ID field into the corresponding Product records.

When I create a new order record on this layout then place my cursor inside the portal, and select a product from the popup list on the Item ID field, the Item text fields get their values looked up correctly but the Item NUMERIC fields remain blank. What am I doing wrong?

Here's a hint. If, after I request the new Order record creation and BEFORE I place my cursor in the portal, I click on whitespace (outside of all fields) in the layout, THEN proceed to select Products in the portal, all of the lookups work fine including the numeric Item fields. Wierd.

Here's another hint: If, after I request the new Order record creation and BEFORE I enter the portal, I perform a find and find this new Order record, then proceed to select Products in the portal, all of the lookups work correctly. Curiouser and curiouser said Alice.

To hack around this problem I've put this latter technique into a script that executes when I request the order record creation and everything is cool now, but I would strongly prefer not to have 'hack' fixes like this in my system, so I need to get to the root cause of this lookup problem. Any ideas why these numeric lookups aren't behaving?

Link to comment
Share on other sites

This topic is 7554 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
 Share

×
×
  • Create New...

Important Information

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