I have earlier done some Access programs but are now a happy Mac user.

I have done a nice application but have one problem, so I made a new databse just to describe the problem.

I have one table called "street" and it carries a street register with the postal number and address.

In my other table "delivery" adress I will add streeets from table "street" and if they are there it will add the postal number & adress automatically. You should be able to write a new address if it is not found and change the postal number and address if you want.

My example works except that if I choose the street "Andersson Street" and selct the secon Andersson street with a different postal number it selects the first one.

I understand I need a unique key but how should I do since I now use two values in the value list, one that I see and the other is street name that I want to put in the record.

Thank´s

Street.fp7.zip

Take a look at the enclosure. I changed the relationship and used calculations to get the related data. Depending on your needs you may want to use lookups. In a final version I would overlay the related Id Field with the street field. Make the field background the same color as the background to hide the related Id.

Street.fp7.zip

Edited February 26, 200916 yr by Guest

Thank you it was almost to easy! I will finish the "Missing manual" before I post more....