O
oscarex
I have 2 tables. Table11 and Table22, also a form for this tables.Form named
FormPP.
In table11, I have a list of products and its model Number identify by the
last 3 digits of a complete serial number. This list never changes, unless I
added new products.
Name Model#
i50 190
i30 300
i205 340
And Table22 is where all the Serial numbers are going to be entered.
Serial# Model#
000123456300 i30
000546896190 i50
000934554340 i205
I need to create a form that when I enter a serial number(Example;
000123456300), I will get the model number automaticaly using a look up
function. The formula should look for the last 3 digits entered in the
Serial#, As you enter the Serial# it should record its Model# in table11 as
well.
Thank you for your help.
Pls be very specific with the steps because I'm not an expert.
I'll apreciate all your help.
FormPP.
In table11, I have a list of products and its model Number identify by the
last 3 digits of a complete serial number. This list never changes, unless I
added new products.
Name Model#
i50 190
i30 300
i205 340
And Table22 is where all the Serial numbers are going to be entered.
Serial# Model#
000123456300 i30
000546896190 i50
000934554340 i205
I need to create a form that when I enter a serial number(Example;
000123456300), I will get the model number automaticaly using a look up
function. The formula should look for the last 3 digits entered in the
Serial#, As you enter the Serial# it should record its Model# in table11 as
well.
Thank you for your help.
Pls be very specific with the steps because I'm not an expert.
I'll apreciate all your help.