July 17, 200817 yr Newbies Hello, I got a table firmen with a primary key pk_firmen, and a table kontake with a primary key pk_kontakt and a foreign key fk_firmen_kontakte. Each company (firma) can have more than 1 contact. There is another table telefon with a foreign key fk_kontakte_telefon. The contacts of a company are given priorities. The telephonenumbers of a contact have also some priorities. On the layout firmen I'd like to display just the contact with the highest priority and the telephonenumber with the highest priority of this contact. How can I now navigate to the next contact with a lesser priority (by pressing a button) ? The telephonenumber should also change accordingly.
Create an account or sign in to comment