A newbie paradox: is this a PK-FK (relationship) problem, orprogramming problem?

  • Thread starter Thread starter raylopez99
  • Start date Start date
tina said:
i had to chuckle at this one, Doug. when i first opened your post, i thought
you were responding to my post, and i couldn't figure out what you were
talking about! then i scrolled down, and found that you were replying to
another post that i had not seen, having blocked that particular user some
time ago. ;)
Click to expand...

I was also wondering as to why there were rather rude comments and
then I see the comp.databases.theory in the newsgroup cross posting
list.
ps. i haven't been in the ngs for quite awhile; nice to "see" you, and i
hope you have a safe and happy holiday! :)
Click to expand...

Nice to see you back as well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Tony said:
<shrug> I have no training in relational design or computers or
whatever. Well not quite I do have 3 credit hours as a teenager.

Tony
Click to expand...

I am sure you are dutifully proud of your ignorance. That's one of the
hallmarks of the vociferous ignorami.
 
(microsoft.public.access.formscoding added back to the newsgroup
listing.)
I am sure you are dutifully proud of your ignorance. That's one of the
hallmarks of the vociferous ignorami.
Click to expand...

Am I supposed to be insulted by your comment?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Tony Toews said:
I was also wondering as to why there were rather rude comments and
then I see the comp.databases.theory in the newsgroup cross posting
list.
Click to expand...

hmm, well, i never pay attention to what groups the message is posted to;
i'm concentrating on trying to help the OP, not worrying about who else
might be reading. though i'm always grateful to have my mistakes corrected
(especially when it's done courteously) because then i learn something, as
well as the OP.
Nice to see you back as well.
Click to expand...

thanks, Tony, happy holidays! :)
 
but i think you're considerably smarter than me, Tony <bows, smiling> i
definitely needed the training i got from the book and the class! :)
 
Tony said:
(microsoft.public.access.formscoding added back to the newsgroup
listing.)
Click to expand...

wow, wish I coulda done that... i had 8 years as a teenager... seemed
longer.
Am I supposed to be insulted by your comment?
Click to expand...

Find an online dictionary and *know* if your supposed to be insulted or
not. BTW, your experience and what you're trying to do make you a
"hacker" not a newbie. Newbies are generally defined as people *in* a
field who are just starting, not people who aren't in a field and don't
plan on being so.

The subject is "relational database design" and it really is a
fascinating field and a useful discipline. There are some well written
books available.

I know a few MVP's; y'all generally work pretty hard trying to make up
for what M$ and their customers can't be arsed to do, so...

Vague oracular hint: a "Stocks" record with Abbreviation as a PK and
possibly <relevant cough> another thing or two might go a long way
towards solving your problem, as well as noting that a screen-display is
a data-structure.


rpl
 
rpl said:
wow, wish I coulda done that... i had 8 years as a teenager... seemed
longer.
Click to expand...

I added Tony to my twit filter so I didn't see this directly. To answer
his question: I don't give a rat's ass about him or any other
self-aggrandizing ignorant. I posted the comment for others so they can
be informed.
 
Bob Badour said:
I added Tony to my twit filter so I didn't see this directly. To answer
his question: I don't give a rat's ass about him or any other
self-aggrandizing ignorant. I posted the comment for others so they can
be informed.
Click to expand...

BWAHAHAHAHA

Thanks. I'll miss you too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
I added Tony to my twit filter so I didn't see this directly. To answer
his question: I don't give a rat's ass about him or any other
self-aggrandizing ignorant. I posted the comment for others so they can
be informed.-
Click to expand...

Hey Bob, isn't 'ignorant' an adjective? So you should write
"ignoramus"! U ignorant or what? LOL.

Insofar as this particular problem(s) goes, I have figured out a lot
of stuff and thanks to everybody's comments. I redesigned the
database using Tina's suggestion (the key concept was the use of a
junction (linking) table to break up two tables that should have been
broken up) and it was very helpful. I also found that sometimes user
interface (what Access calls the "forms") seems to want to dictate
what the database architecture looks like, but you should resist this
temptation in favour of keeping the architecture clean. So I
redesigned the forms to eliminate some redundant data and keep the dB
in 3NF (or something that looks to me close to 3NF).

This dB programming through Visual Basic is kind of cool....and so far
I haven't opened a single book on VB (and don't plan to), you can get
all you need online...

Thanks everybody,

RL
 
rpl said:
Find an online dictionary and *know* if your supposed to be insulted or
not.
Click to expand...

Not worth the time.
BTW, your experience and what you're trying to do make you a
"hacker" not a newbie. Newbies are generally defined as people *in* a
field who are just starting, not people who aren't in a field and don't
plan on being so.
Click to expand...

Umm, but I'm not the original poster. I consider myself to be
somewhere in the systems analyst/programmer/developer/business analyst
continuum.

I may not have the theory but I do design and create some fairly large
systems in Access. At least very large in terms of Access. Not, of
course, as large as some enterprise systems with hundreds or thousands
of users.

http://blog.datamanagementsolutions.biz/2006/05/real-world-access-6.html

Tony


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Bob said:
I added Tony to my twit filter so I didn't see this directly. To answer
his question: I don't give a rat's ass about him or any other
self-aggrandizing ignorant. I posted the comment for others so they can
be informed.
Click to expand...

Well, I originally thought Tony was Ray; I had cancelled the post you
copied it from a couple minutes after I posted it... but glad to be of
service :D


rpl
 
Back
Top