Re: Adding new customer or vendor...

[alta <al...@al...>]

Philip ...

I have loaded the customer table externally, and it seems to be the 
only table needed for customer info.  Note that for each record, you 
have to provide an integer id that does not conflict with another 
identical number in another record.  If you do not take care, you may 
end up with double records with the same id, as the id field is not 
UNIQUE in the customer table.  Otherwise, the process is 
straight-forward.

... Reed

On Friday 28 December 2001 08:53, you wrote:
> Hello everyone,
> I'm trying to build a bridge between the groupware solution we are
> using and sql-ledger.
> Both are using postgresql, so I was thinking I use a single
> database for both programs and write a trigger that updates the
> customer and vendor relation for sql-ledger every time I add or
> edit a contact in my groupware. The groupware has fields which make
> it possible to distinguish between vendor and customer.
> So far everything seems pretty straightforward. My question is:
> When I add a customer or vendor through the webinterface, are only
> the customer or vendor relation affected or is there more to do?
>
> Any help would be highly appreciated.
>
> Bye,
> Philip

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...