I have a simple 'patient' table with the fields: ID_patient, last_name and first_name.

I would like to have a popup that would show the concatenated first_name & last_name and when the selected, would show the associated record in the same layout as the popup and name fields.

It seems like the popup function is designed to just allow replacement of a designated field by the selected content in the popup?

Thanks :

You can use a popup menu that consists of two fields, the patientID and the NameFull_c for navigation from one patient record to another, but I think that you're heading in the wrong direction. The patient list is going to get too long for a popup menu.

Just create a list view of patients, and a form view. Have a button on the list view that goes to the form view layout and vice versa.

I 'did' create a popup menu as you described but I can't get how to use it to navigate to the designated record.

It seems that "Display Data From: Current table" mandates that the popup date will be put in the designated field. Since I don't want to do that, I am stumped.

By the way, this problem is just a proof of concept problem. The real application is much larger and more complicated.

Thanks

here's an example of using a value list for navigation. I still think you shouldn't use this interface technique.

popupnav.zip

Thank you *VERY* much for the example.

I noticed that in your popup example you used 'and' between the two fields. Since I just picked the fields I was not using 'and'. Apparently that makes a difference.

Thanks again.

Ron

Thanks for your help. Your example was an eye opener concerning table record pointers and record focus.

Onto the next problem... whatever that is.

PatientPOPUP.zip

Edited October 3, 200718 yr by Guest

You have your fields set incorrectly. Popup is Patient TO and Layout Fields are Patient2 TO. Then it will work.

HTH

Thanks a lot.