RE: Customers & Vendors

[Dieter S. <dsi...@sq...>]

Hi Peter!

For multiple shipping addresses you'd have to add another table (shipto)
and link it to the 'ar' table.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Fri, 4 Jan 2002, ma...@ds... wrote:

> Hi Peter,
> 
> Why not create all retail branches in client table, with billing info to
> head office and shipping info to retail branch?  I did not check if SL
> offers 2 addresses for the client, but it would be an easy fix to simply add
> a 2nd address in client table.
> 
> Here is an example:
> Tim Hortons - Head Office |
> 1 Central Avenue          | Billing Address
> Suite 5000
> New York, NY
> 123456
> 
> Tim Hortons - Plattsburg
> 2 Main Road			  | Shipping Address
> Plattsburg, Ney York
> 44455555
> 
> ...
> 
> Good luck!
> Sergio
> 
> 
>