Hi. I have 2 tables. I'd like to to set a relationship between them.
The first table has an ID like XXXXX, while the second table has the same ID but written in different way: X-XX-XX.
At the moment I set the relationship outside Access , for example using SUBSTITUTE([columnname], "-", "")
Apparently there is a similar function (REPLACE) in Access , but I am not sure how this function can be used in a relationship.
Any suggestion? Thanks