Hi All,
Table1: tblDrawingNo
Table2: tblType
———————————–
tblDrawingNo:
Field1: DwgNoID–AN
Field2: DwgNo–txt
SampleData: M123,M124, P456, P457
tblType:
Field1: TypeID–AN
Field2: Type–txt
SampleData: M,E,W,P
—————————————
Form:
ControlSource: tblDrawings
Textbox(bound): DrawingNo
ComboBox(bound): cboType
Problem:
When the user inputs a Type in cboType, I need cboDrawingNo to determine the next number respective to the type in cboType and apply it to the field. i.e. if Type = M then the value should be M125 in DrawingNo or if Type = P then the value would be P458.
How can I accomplish this? My first thought was to use the DMax+1 but I can’t figure out how to have Access determine the Type.
I would REALLY appreciate any help.
Thanks,