Reply to thread

Message: <blockquote data-quote="javapadawan" data-source="post: 1266364" data-attributes="member: 1444">Hi Sir Whiskers,Thanks for pointing out the missing relationship set up... I should have put that in to make it easier for others looking at the db to see how it all fits together. Since I only use the database to store data, and manipulate it mainly through a Java interface, I tend to forget stuff like that. *smacks forehead*Tomorrow afternoon I'll post a brief summary here of how it all fits together, and upload another copy of the db with the relationships set up (I'd do it now, but I'm home, and my db and all my notes are at work). I didn't post it previously cause it's a lot of information, and I wasn't sure if anyone would actually be interested in reading it. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />I did import all the spells from a plain text file of the SRD, which is indeed why I have no form set up for entering new spells. I set up the attribute form for a couple reasons, though. The first was just to make it easier to verify that the information was parsed correctly; I find it much easier to match up the text descriptions for the attributes and types than the IDs. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" /> In addition, I plan to add more information for some of the attributes, like prices for costly components, and page numbers for the source attribute, and since I don't have a Java UI set up for that yet, the form was just the quickest way to go.If you or anyone else wants to add more forms and reports, that would be great! I'd love to see what people who actually know how to use Access can do (as opposed to myself; I'm a very basic user. I can create tables, simple forms... and, uh... did I mention I can create tables? <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin    :D"  data-smilie="8"data-shortname=":D" />)Anyway, you're quite welcome, and I'll post the updated db and more details tomorrow.</blockquote>

Verification