S
S N
I have an access database table ([Table1]) in which I have many fields
related to fields from other tables [Table2], [Table3]] etc.
The fields [Field1-1] from [Table1] is related to [field2-2] from [Table2]
in one-many relationship.
Currently the field [Field1-1] from [Table1] contains the full text from
[field2-2] of [Table2]. whereas I want to store the index values (from
autonumber field) from [Field2-1] from [Table2] in the [Table1] instead of
the full text value from [Table2].
How can I replace the full text value in [Table1] with index values from
[Table2] without having to retype all the values.
Kindly advise.
related to fields from other tables [Table2], [Table3]] etc.
The fields [Field1-1] from [Table1] is related to [field2-2] from [Table2]
in one-many relationship.
Currently the field [Field1-1] from [Table1] contains the full text from
[field2-2] of [Table2]. whereas I want to store the index values (from
autonumber field) from [Field2-1] from [Table2] in the [Table1] instead of
the full text value from [Table2].
How can I replace the full text value in [Table1] with index values from
[Table2] without having to retype all the values.
Kindly advise.