Recent content by tjames

I am new with MS Access and I have developed a small database which is working perfectly. But I have the following issue and I could not do it myself and I tried all the ways. Please find attached a jpg file "tbl&frm" containing a sample table and form for MS Access 2007. In the table...

Probably I might be doing wrong. But I tried everything and still I could not make it work. Can anyone help me solve this problem? Would be grateful, if anyone could do it. Thanks & regards.

Thank you Kryst51. I would prefer to do your first suggestion. In second case, whenever I get new aircraft, the update might require to touch this coding, so I don't want to do that. Will let you know very soon if it is working.

I have two fields; Aircraft_Reg and Aircraft_Type on a form pulled out from the table (tblAircraft_Details) in MS Access 2007 as following: Aircraft_Reg: Aircraft_Type: tblAircraft_Details...