Hi,
I have 2 fields, SUB and MAIN
SUB MAIN
0221 02215678
0320 03206654
0560 05603049
SUB is always the first 4 digits from MAIN. If I add data to this table in table view, I want the SUB to be auto entered from MAIN (left([MAIN];4)
Now the problem is, it isn't posible...