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

Re: Suitable for artisan?



This is probably after the fact, but for my own knowledge if nothing else, 
as this is a situation I expect to run into eventually:

On Fri, 21 Nov 2008, Simon Haines wrote:

> Thanks all for the follow-up. I probably won't use a trigger to unify the
> concepts of 'customer' and 'warehouse' because she may eventually want to
> flog her wares on a web site or direct to customers. I think it would be
> better to modify the schema to indicate a customer is a consignment customer
> and tie in the warehouse workflow around that. I'll do some experimenting
> and see how we go.

Just guessing, but couldn't he create a customer group called "consignment 
customers", and then when creating a new customer, have that be a 
component of the trigger--I.E. if it is not set, then no warehouse is 
created?

Been a while since I've actually created any customers (darn it!), so I 
could be forgetting something.

Luke