From: Heinz Huber <Heinz.Huber@elbanet.co.at>
Subject: Re: I am confused as to whether I should use numeric IDs or not
Date: 2000/02/02
Message-ID: <389833F1.4814C2F5@elbanet.co.at>#1/1
Content-Transfer-Encoding: 7bit
References: <W3wl4.54985$zU5.751457@wbnws01.ne.mediaone.net> <pbCl4.27569$L4.49850818@rmnws01.ce.mediaone.net>
X-Accept-Language: de-AU,de,en,fr
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@netway.at
X-Trace: news.netway.at 949498866 11327 195.248.40.66 (2 Feb 2000 13:41:06 GMT)
Organization: NETWAY AG (Customer)
Mime-Version: 1.0
NNTP-Posting-Date: 2 Feb 2000 13:41:06 GMT
Newsgroups: comp.database.oracle,comp.databases.ms-access,comp.databases.theory




> Tony Perovic wrote:
> 
> Keep the tables normalized and use views to pull together the data you
> need for VB using views like this:
> 
> SELECT Contact-History.*
>        Customers.Customer_name,
>        Contacts.Contact_name,
>        SalesPeople.Salesperson_name,
>   FROM Contact-History
>        INNER JOIN Contacts ON Contact-History.ContactID =
> Contacts.Contactid
>        INNER JOIN Customers ON Contact-History.CustomerID =
> Customers.Contactid
>        INNER JOIN Salespeople ON Contact-History.SalesPersonID =
> Contacts.SalesPersonID
>   WHERE ...
>   ORDER BY ...

But keep in mind, that the view will probably not be updateable.

Heinz