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.
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.