Form design problem

Niniel

Registered User.
Local time
Today, 11:54
Joined
Sep 28, 2006
Messages
191
Hello,

For the life of me, I cannot think of a way to make this work. :(
I have this continuous subform, and I need to put additional fields onto it.
The easiest way to do this would be to create single record sub-subforms, but
that won't work because Access won't let me put another subform on a
continuous subform.
My underlying tables are as follows: tblA for the subform has a TableA-ID
PK, and a RecordID FK [that's its link to the main table], plus several other
fields to hold information. Table B has a TableB-ID as a PK, TableA-ID as a
FK, TableC-ID as a FK, a Yes/No field and a text field. Table C has TableC-ID
as a PK, and a text field.
When a new record is created in table A, a number of new records are also
created in table B depending on the number of records in table C [with an
append operation]. There are 6 entries in table C, so table B will contain 6
records for every record in table A.
Subform A needs to show these records, but as I said above, I just cannot
think of a way to make it work.

Any suggestions will be very welcome.

Thank you.
 
Hm, I'm not sure that this will solve my problem, but it's certainly a new idea... Thank you.
 
It looks like the side-by-side method only shows additional information for one record at a time. Unfortunately, I have to be able to view, and more importantly print, all the information at the same time.
 
Niniel:

You can show all the information in one subform. Just don't link to the main form and it will show everything. I have done this with a form in a database for that.
 
That would be great if it would work... But what do you mean with "not link it to the main form"? Could you possibly post an example file?
 

Users who are viewing this thread

Back
Top Bottom