Forms 3.0 Question

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:

1. _______

	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 19 1993 - 22:57:29 CET