FORMS4.0 Question, relations between 3 blocks
Date: 1995/09/22
Message-ID: <Pine.SUN.3.91.950922162402.29520A-100000_at_thor.srl.caltech.edu>#1/1
paper:
paper_id, title, journal, volume, number, page, year, ...
author:
author_id, last_name, first_name, ...
publication:
paper_id, author_num, author_id
paper_id, author_num, author_id
.. .. ..
23 1 45
23 2 3
23 3 57
23 4 18
.. .. ..
which means paper # 23 has 4 authors, their id are 45, 3, 57, and 18.
I am trying to create a form with a layout like this,
|======================================================================| | Paper Id ___________ | | Title __________________________________________ |
| Journal ______________________ |
| Volume ___________ Number _______ Page ______ Year _______ |
| |
|======================================================================|
| |
| Author Id Last Name First Name |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| _________ _________ __________ |
| |
|======================================================================|
I have tried something out using Forms 4.0. I used three blocks,
block_a (base table paper), displays 1 record, block_b (base table publication), displays 10 records, block_c (base table author), display 10 records
and following relations,
block_b.paper_id=block_a.paper_id, block_c.author_id=block_b.author_id
Any suggestions to solve this problem, or any idea on how to design a form like this ?
Your help will be greatly appreicated. Thanks!
Alan M. Lin
Space Radiation Laboratory
California Institute of Technology
Tel: (818) 397-7072 Fax: (818) 397-7111
Email: alanlin_at_thor.srl.caltech.edu
Mail Stop: 220-22
Received on Fri Sep 22 1995 - 00:00:00 CEST