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

From: Douglas J. Steele <>
Date: Sat, 22 Dec 2007 15:51:57 -0500
Message-ID: <#DrWlyNRIHA.3400_at_TK2MSFTNGP03.phx.gbl>

I don't see you making any suggestions. Surely you don't think that one table per brokerage could ever be an appropriate answer!

Doug Steele, Microsoft Access MVP
(no private e-mails, please)

"Bob Badour" <> wrote in message 

> You also don't know a damned thing about his requirements. I find it
> absurd to offer a detailed design on the basis of complete ignorance.
>>>As I type this, I believe the cleanest approach is simply to have many
>>>tables for different stock accounts for this individual: one table
>>>per brokerage, say the person might have an IRA stock account, a
>>>speculative stock account, a conservative stock account, etc, with
>>>different stock brokerage account numbers, and with the accounts all
>>>buying on occasion the same stock (same stock symbol), and that's
>>>Any thoughts?
Received on Sat Dec 22 2007 - 21:51:57 CET

Original text of this message