how to create calculation auto-enter for related fields

[digit]

Hi

I would be most grateful if you could help me with creating a calculation field.

I have 3 tables related with an 'id'. The first table is the one that has all the 'real' fields and the two other tables only have the 'id' field while they are the ones whose non-existent fields are filled in and automatically entered into the first table. (does this make sense?). the first table is not visible to other users.

I would like to create a calculation field in the first table, that when someone enters data into the 2nd table, the 'item' field in the first table will be auto-entered as 'one', while when the 3rd table is filled in, the 'item' field will be auto-entered as 'two'.

Is that possible?

Many thanks!

[bcooney]

Digit,

I'd rather explore your data model in more detail. Can you provide real details of what you're trying to achieve? What are the tables?