Default Value in lookup field

[ruiascensao]

Hi,
How can I have a default value in a lookup field when I create a record?

Lookup field : unit_visa_id

Table to lookup: 'visa'
Fields : visa_id, visa_code, visa_name

I tried ....

Code: Select all

document.getElementById('unit_visa_id').value        = '14f84453ade474';

but it doesn't work ...
How can I do this using JavaScript or sql?

Thank you!

Best Regards,
Rui

[admin]

Rui,

Its done in SQL..

Capture.PNG

Steven

[ruiascensao]

It's working. )
Thank you Steven!

Regards,
Rui

[admin]

.