re: Forms 3.0 Question

In article <1993Nov19.215729.27988_at_cs.UAlberta.CA> carolyn_at_gwynne.cs.ualberta.ca (Carolyn Morris) writes:
>We have been unable to design a form to solve the following problem:
>
>We have 3 tables:
> table1 - with field a
> table2 - with fields a, b
> table3 - with fields b, c
>
>We would like to produce a form where you enter the value of
>a and all the values of b from table 2 are displayed along
>with the corresponding value of c from table3. Table3 may not
>contain any rows, and the end result of the form is to insert
>values of c into table3.
>
>Fields b and c are multi-record, as in:
>
> a: _______
>
> b c
> _____ _____
> _____ _____
> _____ _____
> ...
>
>
>So, to make b and c multi-record blocks that scroll together,
>can we put them in 2 separate blocks? Do they have to be in
>1 block? If so, should the base table be table2 or table3?
>If table2, then when we commit the changes to table3 how do
>we avoid getting an error that there are no rows to commit?
>If table 3, then how do we get the all of the values of b
>to fill in?
>
>Thanks in advance for any suggestions/solutions.
Received on Fri Nov 26 1993 - 17:11:23 CET