@echovtornewell said in When you rely on AI coding...:

Otherwise, you end up with mysterious magic code that no one remembers writing.

We had that long before AI.

I use T-SQL so it may not be quite the same, but I'd implement this with a link table.

Table tPart would have field idPart plus other part info; table tGroup would have field idGroup and other group info. Then table tPartGroup has fields idPart and idGroup, each as foreign keys to their respective tables. No NULL entries needed.

Adding or removing parts in groups only updates the tPartGroup table. The foreign keys prevent deleting a non-empty group or deleting a grouped part. If a part can only be in one group, then this just adds a UNIQUE constraint on the idPart field (I assume MySQL has this). Counting parts in a group is a simple query.

Of course, if the parts are ordered in the group, then an additional field is needed on tPartGroup.

As to what's the best way...?

... when I came across CodeProject.com, and, in a moment of nostalgia, thought I'd see if there was anything still there.

Pleased to see it's being revived and people are finding it again.

Wordle 1,217 4/6* ⬛🟩⬛🟩⬛ 🟩🟩🟩🟩⬛ 🟩🟩🟩🟩⬛ 🟩🟩🟩🟩🟩

Of course the ideal would be to display them in a similar way to this... Scale of Universe[^] Planck length to observable universe in one image!

Wordle 1,215 3/6* 🟨🟨⬛🟩⬛ ⬛⬛🟩🟩🟩 🟩🟩🟩🟩🟩

Wordle 1,214 X/6* ⬛⬛🟨⬛🟨 ⬛🟩⬛🟩🟩 ⬛🟩⬛🟩🟩 ⬛🟩⬛🟩🟩 🟩🟩⬛🟩🟩 🟩🟩⬛🟩🟩 Ran out of lines. For me, that's not a common word!

It's not actually an image. The Wordle site creates it out of character codes (🟨⬛🟩) when you click "share".

Wordle 1,213 4/6* 🟨🟨⬛⬛⬛ ⬛⬛🟨🟨⬛ 🟩⬛⬛🟨🟩 🟩🟩🟩🟩🟩

You obviously didn't see I'd already posted...The Lounge[^]

Wordle 1,212 3/6* ⬛⬛🟩🟩🟩 ⬛⬛🟩🟩🟩 🟩🟩🟩🟩🟩 Having got 3 out of 5 on the first row it was just a case of trying combinations.

Wordle 1,211 2/6* 🟨🟩⬛🟨⬛ 🟩🟩🟩🟩🟩 I've read a lot of interesting articles and discussion over the years and if CP dies where else am I going to post my Wordle result? :-D

Wordle 1,208 5/6* ⬛⬛🟨⬛⬛ ⬛🟩⬛⬛⬛ ⬛🟩⬛🟩🟩 ⬛🟩🟩🟩🟩 🟩🟩🟩🟩🟩

Wordle 1,207 3/6* ⬛🟨🟨🟩⬛ ⬛🟩🟩🟩🟩 🟩🟩🟩🟩🟩

Wordle 1,206 5/6* ⬛⬛🟩⬛⬛ ⬛⬛🟩⬛🟨 ⬛⬛🟩🟨⬛ ⬛🟩🟩🟩⬛ 🟩🟩🟩🟩🟩

Wordle 1,205 4/6* 🟨⬛⬛⬛🟨 ⬛⬛🟨🟨🟩 ⬛🟩🟩🟩🟩 🟩🟩🟩🟩🟩

Du jour? I've several times commented to out service desk people that, never mind the operators, can't we at least train the field tech engineers to use the Print Screen button when reporting a problem. A full screen image would infinitely better that some of the photos we get taken from to far away to be useful, at a slight angle and with a bright light reflecting off the screen for good measure! Since we have remote access to the operator workstations it wouldn't matter if they left the file on the PC...

Wordle 1,204 4/6* ⬛⬛⬛🟨🟨 ⬛⬛🟨🟨🟨 🟨🟩⬛🟩🟨 🟩🟩🟩🟩🟩

Wordle 1,203 4/6* ⬛🟨⬛⬛🟩 ⬛⬛🟨🟨🟩 🟩⬛🟨⬛🟩 🟩🟩🟩🟩🟩

Wordle 1,202 4/6* 🟨⬛🟨🟨⬛ ⬛🟩⬛🟩🟩 ⬛🟩⬛🟩🟩 🟩🟩🟩🟩🟩 Luck!