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

[Tony Toews [MVP]]

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.

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!

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/

 

[Bob Badour]

(microsoft.public.access.formscoding added back in.)


BWAHAHAHAHAHA

Thanks for the guffaw.

Tony

You're welcome.

(Simple minds are so easily amused.)

 

[Bob Badour]

<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

I am sure you are dutifully proud of your ignorance. That's one of the
hallmarks of the vociferous ignorami.

 

[Tony Toews [MVP]]

(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.

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/

 

[tina]

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.

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.

thanks, Tony, happy holidays!

 

[tina]

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!

 

[rpl]

(microsoft.public.access.formscoding added back to the newsgroup
listing.)

wow, wish I coulda done that... i had 8 years as a teenager... seemed
longer.

Am I supposed to be insulted by your comment?

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

 

[Bob Badour]

wow, wish I coulda done that... i had 8 years as a teenager... seemed
longer.

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.

 

[Tony Toews [MVP]]

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.

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/

 

[raylopez99]

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.-

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

 

[Bob Badour]

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

Not when I used it.

 

[Tony Toews [MVP]]

Find an online dictionary and *know* if your supposed to be insulted or
not.

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.

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/

 

[rpl]

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.

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


rpl