I HAVE A LOOK UP FIELD, BUT IT ALWAYS GO FOR MAXIMUM NUMBER OF RECORD ID OF PARENT TABLE, BUT I DON'T WANT TO SELECT ON IT. IT THERE IS A WAY FOR ME TO AUTO CHOSE THE RECORD ID I WANT AND NOT TO CHOSE FROM THE DROP DOWN? I DON'T WANT TO CLICK ON IT AND SCROLL ALL THE WAY DOWN TO CHOOSE THE MAXIMUM RECORD ID NUMBER OF OTHER TABLE, IT COST ME A LOT OF TIME.
------------------------------
Golden West
------------------------------