In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails.
The transaction was initiated by a C# program using a table adapter...

I thougt of 2 possibilites:
Possibility 1.
Table 1: French vocabulary
Table 2: English vocabulary
Table 3: Translation table containing primary keys of table 1 and 2

Possibility 2.
French...

Need your help:)

Got the following problem:
A French vocable got one or more English vocable equivalents and vice versa.
What is the best way to store these information in table(s)?

Thanks...