Recent content by Binksy

I am getting the following error: The changes you requested to the table were not sucessful because they would create duplicate values in the index, primary key or relationship. I think I have isolated the error to two tables that I have for a combobox, so that the user has a list of options...

What i need precisely is the last digit or digits of the first section of the british post code system: BB1 4HU ^ and BB12 4HU ^^ are valid post codes but give very different results, when the user inputs the postcode, they enter it as one chunk: "Postcode...

i have been trying (unsuccessfully) to get the last character of a string using STRLEN. The string is a postcode(UK) which consists of numbers and chars. How do i get delphi to read the string backwards. I am using delphi 2.0. Many thanks - Binksy

Got is sussed!!! it was the fact that i had to change the duplicates to allowed in one table and no duplicates in the other. i had to get one of the top bods in who just walked in and realised the problem straight away. MS bloody access makes me feel like a fool!!! :)

im gonna give it a go now!!!

Thanks for the tip, but when i made sure that indexes and fields were correct and deleted relationships and started again, it did exactly the same. I asked a lecturer at my college, and he does not have the fogiest!!! :( My relationships: Member --- Acc Holders --- Account --- Statement (One)...

I've created an Access database with several tables, and when i have tried to create relationships between two tables (one-to-many) following the instructions in the Access manual, the relationship somehow reverses (becomes a many-to-one) Binksy