Page 1 of 1

Default Value in lookup field

Posted: Wed Apr 11, 2012 6:52 pm
by 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

Re: Default Value in lookup field

Posted: Thu Apr 12, 2012 8:02 am
by admin
Rui,

Its done in SQL..
Capture.PNG

Steven

Re: Default Value in lookup field

Posted: Thu Apr 12, 2012 5:29 pm
by ruiascensao
It's working. :o)
Thank you Steven!

Regards,
Rui

Re: Default Value in lookup field

Posted: Fri Apr 13, 2012 9:13 am
by admin
.