fcvdb
06-02-2000, 10:38 AM
I want to create a form to enter/maintain data in a table (Table E) as follows:
Table A has primary key a
Table B bas primary key a+b
Table C has primary key a+b+c
Table D has primary key a+d
Table E has primary key a+b+c+d
I have forms to enter/maintain data in tables A, B and D and a subform to enter/maintain data in Table C using Table B information (read-only) on the parent form. Now I want to create a subform to enter/maintain Table E utilizing table A, B, C and D information (read-only) on the parent form.
Does anyone know how to craft the queryies and forms required for this? Remember Table E will not have any data in it when the other do, I want to use this form to "fill in"
Table A has primary key a
Table B bas primary key a+b
Table C has primary key a+b+c
Table D has primary key a+d
Table E has primary key a+b+c+d
I have forms to enter/maintain data in tables A, B and D and a subform to enter/maintain data in Table C using Table B information (read-only) on the parent form. Now I want to create a subform to enter/maintain Table E utilizing table A, B, C and D information (read-only) on the parent form.
Does anyone know how to craft the queryies and forms required for this? Remember Table E will not have any data in it when the other do, I want to use this form to "fill in"