Reply to thread

Message

<blockquote data-quote="Sir Whiskers" data-source="post: 1266113" data-attributes="member: 6941">Thanks for posting this. I've only had time to take a quick look, but I noticed a couple things:1. The first thing I look at when figuring out someone else's db is the relationships screen - it's a quick way to see how everything fits together. I was rather surprised to see that it was blank. Did you create the relationships at the form level? Do you mind posting a short summary of the relationships between the various tables? (Something easy, like &quot;tblAttribute.attributeID [one to many] tblSpell.attribute&quot; - and yes, I made up these table/field names for example purposes)2. The spell attributes form allows a user to enter/modify attributes for spells, but not new spells. Is there no spell form because you imported the data? I'm just guessing that you used this form to break out the attribute info for each imported spell, but otherwise I can't think what purpose it serves.I don't know when I'll have time, but if I (or someone else) creates forms and reports for the db, do you want copies? Alternately, we can post mods to this thread, though I'd recommend we each change the db filename slightly - I don't want to over-write my db with someone else's, when I just plan to import an object or two.Again, many thanks for all the hard work!</blockquote>

[QUOTE="Sir Whiskers, post: 1266113, member: 6941"] Thanks for posting this. I've only had time to take a quick look, but I noticed a couple things: 1. The first thing I look at when figuring out someone else's db is the relationships screen - it's a quick way to see how everything fits together. I was rather surprised to see that it was blank. Did you create the relationships at the form level? Do you mind posting a short summary of the relationships between the various tables? (Something easy, like "tblAttribute.attributeID [one to many] tblSpell.attribute" - and yes, I made up these table/field names for example purposes) 2. The spell attributes form allows a user to enter/modify attributes for spells, but not new spells. Is there no spell form because you imported the data? I'm just guessing that you used this form to break out the attribute info for each imported spell, but otherwise I can't think what purpose it serves. I don't know when I'll have time, but if I (or someone else) creates forms and reports for the db, do you want copies? Alternately, we can post mods to this thread, though I'd recommend we each change the db filename slightly - I don't want to over-write my db with someone else's, when I just plan to import an object or two. Again, many thanks for all the hard work! [/QUOTE]

Verification