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

From: Douglas J. Steele <NOSPAM_djsteele_at_NOSPAM_canada.com>
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
http://I.Am/DougSteele
(no private e-mails, please)


"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message 
news:476d71c2$0$5279$9a566e8b_at_news.aliant.net...

>
> 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
>>>fine.
>>>
>>>Any thoughts?
>>>
>>>RL
>>
>>
Received on Sat Dec 22 2007 - 21:51:57 CET

Original text of this message