Displaying one field in dropdown but storing another

[RayWindlow47079]

Hi Folks

I think I asked this couple years back but at a lesser level.

We currently are struggling to stay within our max record count as an NFP and if possible would rather keep the balance where we are than having to find more sponsorship funding.

So the issue is, we have a database with the details of decease of a soldier POST WAR.

One of our researchers record where the deceased is interred (cemetery or crematorium).

As you can imagine there a literally thousands but for many there may be one or no entries for a particular location. So creating thousands of cemetery location records is just not practical particularly knowing the restraints we work with.

Our field are Code, Cemetery Precinct , Cemeteries/Crematorums (possible multiple lines).

In essence a Precinct may have multiple locations to which we are manually naming with a code, an abbrevation of the actual name of the locations

So in this example we may get plenty of use out of 2 of the alternate names but none for the others, we just don’t know.

So our wrok around is when they record a finding they add the code in brackets onto the grave reference so the final entry resembles this

Rookwood Necropolis Grave Reference is Plot XVII Grave 12 (SWC)

So the problem is,

I want to be able to display and search on the alternate names in the dropdown BUT STORE the Cemetery Name in the Personnel Record !

If I put the Alternate names as the display field in the dropdown THAT IS WHAT GETS STORED in the Personnel File, long winded and with lots of not relevant data.

Any thoughts oh wizards of the KNACKERY - much appreciate your time

Ray

[RayWindlow47079]

Update to this and only leaving it only as learning curve to other

The display field is just that, what is displayed in tables etc but is not what is physically stored.

That remains set to whatever the table definition dictates (in this case Cemetery Name)

So by doing a text formula to determine what the “top level” Cemetery Name is from the connected file I can use that for displaying in reports, details displays etc and not necessarily what is showing in the connected field.

The importance of that is not to make the Memorial-Data used elsewhere for presentation into a long winded collection of information that’s not relevant as shown below !