[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Suitable for artisan?



On Wed, Nov 19, 2008 at 2:00 AM, Stroller
<..hidden..> wrote:
>
> On 18 Nov 2008, at 22:26, Simon Haines wrote:
>
> She creates a customer called "Jane's Jewellery Store" and also, separately,
> a warehouse called "Jane's Jewellery Store". When she sells the item to
> the "Jane's Jewellery Store" customer she ships it from the "Jane's
> Jewellery Store" warehouse.
> Stroller.
>

One way to automate this would be to create a trigger which creates a
warehouse for every customer.  The only problem is that if she ever
does have direct sales.....

Another option would be to add the records the warehouse table via
Perl when the customer is created.

Best Wishes,
Chris Travers