Inserting Lots of fields into multiple tables

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
>