Re: Storing mutiple child records with same FK
Date: Wed, 24 Dec 2003 08:20:32 -0500
Message-ID: <h9ydna0G1_l6D3SiRVn-tA_at_comcast.com>
"DENNIS DUTCAVICH" <dennyjd_at_optonline.net> wrote in message
news:EqIFb.366658$655.76047207_at_news4.srv.hcvlny.cv.net...
| I am building what should be a simple form. Its a stacked form. One block
is
| 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
them
| away. I can't seem to pick up the primary key from the book table and
store
| 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