Jim, You can actually make this without adding the record to your table; this is how you do it:
Create a table AddModel Table with the same fields you display in your pop-up, say ModelNo and ModelDesc Add one record to the new table with the values ' ==>' and 'Add New Record' Note the blank space in front of "==>" Create a temporary or permanent view: CREATE VIEW AddModelView AS SELECT ModelNo, ModelDesc FROM ModelTable + UNION SELECT ModelNo, ModelDesc FROM AddModel Now, use the view AddModelView on your pop-up ORDER BY ModelNo and the record: " ==> Add New model" will always be displayed on the first row. No need to modify your ModelTable with records that you will have to later exclude on reports. On EXIT from the field, you can capture the value of the ModelNo and if it is equal to " ==>" then open a form or prompt the user to enter a new model and then use the PROPERTY command to update the value of your field. This approach works better than adding a record to your model table and you can make the AddModel table generic so you can use it to display a prompt to add new records to other tables as well. Javier, Javier Valencia 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, October 16, 2009 3:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: getting info or enter new Dave & Dick, The field is a DB edit field with the automatic popup. Let me see if I understand your suggestion. My table name is Product. Are you saying I have a row in that table that has as the model name 'Add New Model'? Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Fitts, David A. Sent: Friday, October 16, 2009 2:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: getting info or enter new Hi Jim, I have used Dick's suggestion and encourage you to try it. I would like to offer a couple suggestions to it if I may. If you put a row like 'Add New Model' with a space in front of the first word, that choice will always be the first item on the pop up list assuming you have it ordered. Doing this also allows the user to tap the space bar to get back to that choice quickly. Second, if you put either a no duplicates rule or a primary key on the field name then the user can try to add a new model only to be told it is already there. Regards, Dave Fitts State of Maine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Friday, October 16, 2009 3:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: getting info or enter new Jim: Put a row in the model data base listing 'Add New Model' When the user clicks that, use the exit eep on the field to trap 'Add New Model' and do whatever you need to do there to enter a new model. We do it all the time. Dick Fey Jim Belisle wrote: > > While entering orders in the Model field, I give the option for the > entry person to lookup the model with a pop up menu. > > They also have the option (by pressing a button next to the model > field) of entering a new model into the proper table so it is > available to use "on the fly". > > This is working fine. > > I have tried making the popup automatic. That works except if they > realize they need to add a model because what they are looking for is > not there (such as parts orders, etc.) when they escape they get an > error because no value is picked from the popup. > > When using an automatic popup is there a way to suppress the error > message if they do not choose an item? > > My purpose is to force them to look carefully first before entering > new models such as parts, but get rid of the error message if they do > have to enter a new model after searching carefully. > > Jim >
