Re: MS ACCES DELPHIE MASTER/SLAVE PROBLEM

Well I miss something So I make indexes but it is still the same.
So that is what I have

I have two tables
1rst table call 'group' has two field (table1)
that is the master table with the name of the different School levels

1rst field = code groupe (ex gr300)
(primary key no double)

2nd field name of the group (ex 2nd level high chool classe A)
indexed no double

2nd table cal F-books has two fields (table2)
That is the slave table with all the books used in each specifique level
sorted by code level

1rst field code level (take the value of the code groupe) (ex gr300)
indexed with double

2nd field has the barre code of the book
indexed with double

On my form, I have 3 grids
grid1-group (group)
grid2-books (f-books)
grid3-table with all my books (table3)

By cliking on the row of the book I choose on the grid3,
I copy the code barre into the
F-books table and the code level is put through the relation

relation from table1.1rst field to table2 1rst field
one to many relation type.
I think I mist something on that level.

In fact that is the same as having a master table with order
and a slave table with the items/product indexed on the order number
But I couldn't find an exemple with MS access.


I am not realy sure I explained properly my system.
Sorry for the lenght of my 'report'
See I you understand and thank anyway for having had a try
claude
"Claude" <livresplus@xxxxxxxx> a écrit dans le message de
news:43384dcc@xxxxxxxxxxxxxxxxxxxxxxxxx
> I use ms access tables with not indexes just a jointrelation between to
> table. In my case a school classe code as master and a list of books for
> the slave table so when on one gride I click the classe I get all the book
> needed for that class
> In the slave grid (table) itis not probleme to delete a book. But when I
put
> twice the same book in the table and want to delete one of them I get an
> EOle Exception with the message "information about the column is not
> suficient or incorrect. Too many ligne are affected.
> When I carry on with the step by step commande I come to a message teeling
> me that the lign doesn 't exist.
> As anyone a clue why I cannot delete this ligne double.
> thanks
> claude
>
>


.

Relevant Pages

  • Re: Replikations Frage
    ... vom Master auf den Slave kopiert hast und dabei die Permissions auf ... Die Datenbanken auf den Slave Server laufen ohne Probleme. ... # If you want to know which options a program support, ...
    (de.comp.datenbanken.mysql)
  • Re: When caveman Uhg invented fire
    ... be a business owner. ... But even the smallest "ownership" makes one a slave. ... Any "slave" can become the master. ...
    (alt.lang.asm)
  • Re: One-sided authentication for small micros?
    ... The master has a lookup table of all 'known' slave id's. ... This would reset all the slave keys to their lookup values. ... decides that it is a valid slave and starts to communicate with the slave. ...
    (sci.crypt)
  • Re: FIXMBR redux
    ... William, I did the best I could for you under the circumstances and I did ... >> "To remove the recovery console, delete the cmdcons folder from the root ... > drive as Master and formatted it anew, as Active and Primary, ... I then jumpered it as Slave, ...
    (microsoft.public.windowsxp.basics)
  • Re: Buffered IO and pipes
    ... master with as little waiting around as possible, ... when another slave would actually be ready to write. ... create a 64kB shared memory buffer for every ... "X" to the slave's pipe. ...
    (comp.unix.solaris)