Re: I am confused as to whether I should use numeric IDs or not

> 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 Received on Wed Feb 02 2000 - 00:00:00 CET