If the inhouse DB file is not keyed, you can check to see if there is a logical built over it by using F14. This should bring up a list of the logicals on the file or the file itself. It lists the key fields used. Once you have selected a keyed file, you can use the F6 key to position to a specific record using the key fields that function key provides. Good luck. Paola Groeber Former MAPICS Business Analyst for CRM applications Also DBU Guru for over 12 years :^) email@example.com aldg wrote: > Hi Mapics group: > > I am trying to edit an inhouse created DB file using DBU. > > When I bring up the file and try to go to a specific record using the F1-KEY >command, I get an error message, "Function key not allowed." > > The DBU help screen for that command says: > > "CMD 1-KEY. Allows a starting key selection on logical or keyed physical >files. If the file has a single record format, the current key is displayed. >Partial keys may be used. Not valid for non-keyed physical files." > > What is the difference between a "keyed" and "non-keyed" DB file? > > When we create inhouse DB files using Query/400, is the resulting file >automatically a "non-keyed" DB file? > > Is there any way to convert a "non-keyed" DB file into a "keyed" DB file? If >there isn't a way to do this, I do I use DBU to go directly to a specific >record on a very large DB file? > > I look forward to your good assistance on this matter. > > Regards, > Al Gershen > Grants Pass, OR > firstname.lastname@example.org > Aldg's Photos at: > http://communities.msn.com/AldgsPhotos/ > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l > or email: MAPICS-Lemail@example.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.