Making field values from different tables the same

[nicnicman]

How would I set the field value in one table to equal the field value in another table? Neither fields are primary keys, but the two tables do have a one-to-many relationship. Basically, I just want the two values to be the same.



Thanks for any help and if more info is needed please let me know.

[alansidman]

This is contrary to normalization rules for databases. There is no need to duplicate information. If the data is in a table and can be retrieved, it can be shown as needed in a query, form or report.

[nicnicman]

Hmm...that's true. The field may not be necessary after all.

[nicnicman]

Thanks for all your help, alansidman!