Specifying default values in add query

[alarabie]

I know how to default fields in add mode to a constant value, but how do I specify the default value to be the content of one of the query fields, in other words when I want to add a new record I want to default the customer ID field to the current customer ID and I dont want to use the copy button because there are to many fields to blank out just keep the customer ID field.

[Frank]

Looks like no easy way to do this one but again let's wait for some input.

Internally, it is pretty easy to implement like ->

if _Def="Moi!" then _Def=Raw_Record_Value

Another way to do that is to run the _Def value through the MagicCell porcessor which is more involved.


Frank

[alarabie]

I worked around the problem by re-retrieving the record in a common table and making the field a drop down which only has one value.

[Frank]

I know there is a solution somewhere. Yours is not bad at all. If it is not good enough, let me know and I'll implement that (takes me about 3 lines of code!).


FK

[John]

Hi,

You can also retrieve it as you are today, but instead of making it a dropdown, just make it a readonly field and set the default value [xxx] to that retrieved value.

John

[Mark]

i agree