Re: Storing mutiple child records with same FK

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 24 Dec 2003 08:20:32 -0500
Message-ID: <>

"DENNIS DUTCAVICH" <> wrote in message news:EqIFb.366658$
| I am building what should be a simple form. Its a stacked form. One block
| a book name and other basic info. The other block is table of content
| entries with pages (two tables, book and toc). I want to enter the basic
| book info, title etc, and then the table of contents entries and store
| away. I can't seem to pick up the primary key from the book table and
| it as a foreign key in the all toc entries in the toc table. Any help or
| direction appreciated...
| --
| Denny

make sure you've got the PKs/FKs declared in the database, then just use the data block wizard to create the dependent blocks -- Forms will create the relationships for you, as well as the set the properties in the FK fields in the dependent block to default to the value in the PK field

  • MCS
Received on Wed Dec 24 2003 - 14:20:32 CET

Original text of this message