Access auto-entered data, possible in table view?

[Tiger__]

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 to use default value and set left([MAIN];4) for the field SUB so it would be auto entered with the 4 first digits from MAIN.

How can I do this IN TABLE VIEW... I tried almoest everything..is this even possible?!!

Many thanks,
Claudio

 

[dcx693]

It's not possible, and even if it were, why bother? You would be violating one of the most basic rules of database design: never store information more times than is necessary. Why store part of one field within another? You can always combine the sub part and the main part in a query, form, or report for display. If you're exporting this information, base your export on a query that combines the information the way you want to see it.

 

[Tiger__]

I know i know..it's defenately not good, but customer is king
I proposed a much better solution, but they want it their way...

Thnx,
Tiger__

 

[neileg]

But, as dcx693 says, it's not possible, even it it was sensible. You can do it in a form or with a query, but not in the table directly.

Why do your users see the tables, anyway? Tables are for storing data, not viewing or entering.