hi

i have two fields that are the same, but in different tables. can i create a relationship so that when one field (in stock) from the purchases table is selected, the same field in the stock table is the same value as the one from the purchases table... i hope i explained it well enough:)

i know this causes data redundancy, but is there any better way of doing this?

thanks

Need more information, but you're going to have to do this in a form, you can't do it at table level.

i know this causes data redundancy, but is there any better way of doing this?

Yes. It is called "normalization" and it very rarely fails to smooth out issues of duplicated data.