I am new at coding, I have followed many tutorials but cant find what I am missing, the stupid method: I tried looping through each record of table A once I have the current record then run another select to find what ever data is in table B that matches the table A id.
But I cant get it to work so I abandoned it. The code is too long and the result is messy. See my image I uploaded, I am running it with SQLite, and its should be vry simple but no where do I find sollutions for this issue. Please point me to a place where I can learn how this done.
I have attached an image of my table layout.
However the resulting JTable won't look like the nice picture which Mike posted. It's going to look more like this not-so-nice picture:
+ Mike + 1 +
+ Mike + 2 +
+ Mike + 7 +
+ Mike + 9 +
+ Carol + 4 +
+ Carol + 5 +
+ Carol + 8 +
It's possible that Mike was complaining about that difference. If that's the case then let me point out that it's possible (with some difficulty) to get the nice version of the JTable but the solution doesn't involve collecting the data in a different way.
posted 1 month ago
Yes I agree, ALLOT more work, so has anyone tried doing a query in a record set and add another query inside the While (rs.next).
I NEVER give up so it will work eventually ...lol
What I have tried so far is this and it works for the first query but the second gives an error, trying t solve it but its looking good so far.
The error code is:
It is given on line 46 when the code is not //
But my screen looks awesome so far!
Once i Get it I will post it!
Thank you guys for the efforts.
EDIT: IT works, I forgot the second Recordset next section!