I again need some help please
My App runs on a MS SQL DB. Amongst other I have two tables that related:
Profiles (With a unique, autonumber Key for SN)
The Profile_Addresses, also With a unique, autonumber Key for SN, and another foreign key for a field called P_SN.
In the Clarion Dictionary the relationship is set as follows Profiles.SN = Profile_Address.P_SN (1 to many)
This work 100% when adding addresses, the P_SN is set to the Profiles.SN
The problem is this:
When I call the addresses procedure it is filtered by File_relationship. This correctly only display the addresses of the record selected in the Profiles browse.
But, it duplicates the one record.
For example: I have a profile with SN = 1. This profile has 2 addresses.
When I open the addresses browse, it shows the first address in row 1, the second address in row 2 and again the first address in row 3.
And further to that, when I then edit one of the addresses and the focus returns to the browse, only the address I edited is shown in the list.
This of course still works, but it looks absolutely un-professional.