Relating a street and housenumber

[LasseJ]

Hi all

I have made a relation ship where a match on 'street' AND 'postal code' relates to coordinate on a citymap.

Since some streets covers more coordinates I would like to know if its possible to make a relationship where I can also add a third (relaxed) match, 'house number' to relate to the coordinate. (Ex. Any number from 1 to 100 relates to coordinate A1 and any number from 101 to 200 relates to A2)

And what if the house number is 13A? Can FM be set up to only look for matches on the number and ignore any letter?

Regards

Lasse

[Søren Dyhr]

There's more to it, the side of the street matters as well, they're hardly ever in sync.

This will give something like 4 fields {lower even; upper even; lower odd; upper odd} , I would probably gather it via a range-CF's e.g. http://www.briandunning.com/cf/14, where I then would change the iteration step to 2. The two resulting lists are then joined via a pilcrow - this will be one of the foreignkeys, the other is the streetname.

On primary side are the fields the streetname and the number where Int(Leftwords(gadenummer);1) strips off both letters and the following in danish addresses.

--sd