idrive72
Member
Hi, not being very experienced, I am having difficulty in realizing the following:
I have created three tables, for simplicity A, B and C. Table A contains 50 Yes / No fields. Table B contains 50 fields of the radiobutton type (each radiobutton has three values, 1,2 and 3). Table C contains 50 fields, all Yes / No. Table B and C is written only by the administrator while table A by the user. In practice, table A varies from user to user and is filled in via a simple form, while table B and C are filled in by the administrator and remain constant over time until the need to modify them arises.
What I need is to build a page that contains a summary table that shows the user the three tables side by side;
- the first column must contain the questions of Table A
- the second column must contain the Yes / No answers from Table A
- the third column must contain the selected radiobutton values from table B
- the fourth column must contain the Yes / No answers from table C
I tried several things, joins and other attempts but honestly I couldn't create a simple summary table.
Do you kindly have any information to give me? I'm melting my head!
A thousand thanks!!!
I have created three tables, for simplicity A, B and C. Table A contains 50 Yes / No fields. Table B contains 50 fields of the radiobutton type (each radiobutton has three values, 1,2 and 3). Table C contains 50 fields, all Yes / No. Table B and C is written only by the administrator while table A by the user. In practice, table A varies from user to user and is filled in via a simple form, while table B and C are filled in by the administrator and remain constant over time until the need to modify them arises.
What I need is to build a page that contains a summary table that shows the user the three tables side by side;
- the first column must contain the questions of Table A
- the second column must contain the Yes / No answers from Table A
- the third column must contain the selected radiobutton values from table B
- the fourth column must contain the Yes / No answers from table C
I tried several things, joins and other attempts but honestly I couldn't create a simple summary table.
Do you kindly have any information to give me? I'm melting my head!
A thousand thanks!!!