Adam
The error means that you are trying to insert a record into a
table that is
dependent upon some of the information being in a higher
table, so you need
to do the inserts in the correct order.
There is an old tutorial on the MM site on how to handle
multiple tabel
inserts, which you may find useful.
--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver
Valleybiz Internet Design
www.valleybiz.net
"muzicmistro" <webforumsuser@macromedia.com> wrote in
message
news:e3fej1$8gp$1@forums.macromedia.com...
> Hi, i would like to enter lots of fields into mutiple
tables in my access
> database. I have 6 pages which in turn have a different
set of forms which
> must
> be inserted into its own table. I tried to insert some
information into
> the
> table but because my database is a relational db i get
an error message
> "You
> cannot add or change a record because a related record
is required in
> table
> 'Hosting'. Im not entirely sure what this error means
but it is quite
> urgent
> that this is sorted. Another way in which i tried it was
to carry all the
> form
> values over each page and recarry them onto the final
'insert' page but i
> cannot insert more than one insert record behavior and
if i do i get a dim
> error message.
>
> Can somebody please help me this is very urgent.
>
> Thanks in advance,
>
> Adam
>
1
Reply
AdChoices