I tried filemaker 5 and its relational database capabilities:
Assume you have clients with a unique login id in database a, you store their login session times in database b:
create database CustomerData, fields: login (type text), data (numeric)
create database Customer, field: login (type text)
Now, make a relation from customer to CustomerData with the login name as relation.
Created a layout in database Customer, add the field "data" from related database "CustomerData"
then type in some data in CustomerData:
user1, 12345
user2, 23456
and add
user1
user2
to database Customer.
Result: the "data" field of database "CustomerData" will be seen in the layout of database "Customer".
Now, lets create a few new users like "#user1" in Customer , "User1" or "-User1" or "user1$" or "-----user1".
Still filemaker will see the data of user1 in CustomerData as related to all those variations of user1 names I created above!
Is this a feature? I tried several other characters, everything which is not alphanumeric characters with a few exeptions will be ignored. I would not care about the upper/lowercase thing but it makes a big difference if I call sombody user1# or user1!
I then tried filemaker 4 and 5, both show this behaviour.
Any Ideas what I did incorrect or should I not expect a different behaviour of filemaker?
thanks