Re: D7-access key problem

The detail table has no primary key just an index on job number with double
possible
Primary key only on the Job table whixh is the master table
claude
"Claude Lec" <livresplus@xxxxxxxx> a écrit dans le message de news:
4428f357@xxxxxxxxxxxxxxxxxxxxxxxxx
I didn check jetz but I think I have the job number which is the joint
field with my detail key as primary key. The code barre of my items databas
wher the items name etc is taken is also a primary key
cluade
"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> a écrit dans le
message de news: 4428f28f@xxxxxxxxxxxxxxxxxxxxxxxxx
Do you have primary keys on detail table (or on all tables affected by
queries)?

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Claude Lec" <livresplus@xxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4428eda7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
D7 ACCESS
I have a master/detail relation with access
On the detail table, if I want to delete one record in the detail
which is more than one time in the details table, I have the exception
"Information on the Key column insuficiant or incorect.To many line are
affected"
But I have just 2 tables with indexe on the 2nd table only on the key
fields
which is index with double possible.
Any Idea
Claude







.

Relevant Pages

  • Re: Search Form - Take 2
    ... While in Design mode, highlight all of the fields you want to include in the ... selected fields to the primary key. ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Re: Search Form - Take 2
    ... selected fields to the primary key. ... description column in Recommendations or Accomplishments you'll have some ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Row cannot be located for updating
    ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
    (borland.public.delphi.database.ado)
  • Re: Row cannot be located for updating
    ... Both primary keys in MasterTable and DetailTable are Autoincrement field ... But the problem seems to be on the Primary key fields, ... > The master linking field in the detail table needs to be of type Integer ...
    (borland.public.delphi.database.ado)
  • Re: Cannot add record for child table that have relationship with master table.
    ... If your tables don't have a relation in the database than you have to add ... Of course have you to create the master record first before you can add any ... detail table have a relationship with th master table with a primary key. ... because of datagrid will automatic add primary key relation to the master ...
    (microsoft.public.dotnet.framework.adonet)