*or you can try:*
db.define_table("tblVehicle",
Field("*VehicleName_id*",db.tblVehicleName,label='Vehicle Name'),
Field("VehicleNo", default=None,label='VehicleNo'),
format=*lambda row: "%s" % row.**VehicleName_id.VehicleName* )
db.tblVehicle.VehicleName.requires=IS_IN_DB(db,'tblVehicleName.id','%(
VehicleName)s')
* # Creating tblDriver adding Driver name and selecting the name of vehicle
from the dropdown*
db.define_table("tblDriver",
Field("DriverName",'string',label='Driver Name'),
Field('id_tblVehicle', db.tblVehicle,label='Vehicle Name'))
db.tblDriver.id_tblVehicle.requires=IS_IN_DB(db, 'tblVehicle.id')
By thw way you have problem with the name you give to the fields, try to
name references with *tablename_id* to avoid confusion.
--
Bruno Rocha
[http://rochacbruno.com.br]
