Hello,
At 15.37 23/04/99 -0400, you wrote:
>I have two databases, oidetail and dispnotes:
>Create table oidetail (
> Autoinv int4 not null,
> Partnum char(6) not null check (partnum<>' '),
...
> Oldrtrn bool default 1,
> Oldrtrndt date
> Constraint ssmsoidetail foreign key (autoinv) references ssms);
it looks like this table doesn't have a primary key. Access, and VB and any
other Microsoft program that uses the MS Jet DB Engine, doesn't let you add
records on a table that doesn't have at least one unique index on it.
Bye!
--Sbragion DenisInfoTecnaTel, Fax: +39 039 2324054URL: http://infotecna.home.dhs.org