Jump to content

Replicate "Show All" in a Multi-Type table


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

Recommended Posts

I'm working on a Ordering system. Orders must have a Type of "Sale", "Purchase", or "Transfer". I originally thought about going with three separate tables, one for each type, but there's a lot of overlap, so I think one is the answer.

The three are different however, and I have a different entry layout for each. What I want to happen is for only the respective type to appear in the respective layout. So I'm scripting the navigation and got the Find process nailed down, but can't replicate Show All.

Everything I've tried (scripts that involve the Find process: Find, Constrain, Extend, GTRR), gets me the proper found set, but the focus has changed from the record I was on to the first record of the set.

Any ideas?

DJ

Link to comment
Share on other sites

One way is to remember the record id, do the find, then scroll through the found set to the original record. (Yeah I know it doesn't scale well but it might work for a while.)

Only other suggestion is to try something with access privileges to prevent the other record types from being seen (this might get ugly with displayed, I dunno).

Link to comment
Share on other sites

New day brings new thoughts. Since I'm moving towards scripting all navigation (eliminating the Status Area), maybe I don't need to do anything to change Show All.

If I script my record navigation to skip records of the typse that don't match the layout, and set my "Found Count" to only show the number of that type, the user will be none the wiser.

Link to comment
Share on other sites

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