Re: [Citrusdb-users] Development work

2012-01-23 Thread Paul Yasi
It's meant to hold the source of the customer in terms of where they heard about your service, advertisement, etc. There is a source report that can produce a total for each source that uses that field. If that doesn't matter right now you could use it to hold a temporary value. I think I would j

Re: [Citrusdb-users] Development work

2012-01-23 Thread Bill Harris
Paul, What is the "source" column used for? Can I use it to hold a temporary value? Bill mysql> describe customer; +--+--+--+-+++ | Field| Type | Null | Key | Default| Extra

Re: [Citrusdb-users] Development work

2012-01-23 Thread Paul Yasi
I don't think it would break anything. Paul On Mon, Jan 23, 2012 at 8:29 AM, Bill Harris wrote: > Paul, > > Our current "homegrown" Access-based system stores the account > name as the account number (legacy from dial-up days).. > > I want to import the customers today, but wondered if I could a

Re: [Citrusdb-users] Development work

2012-01-23 Thread Bill Harris
Paul, Our current "homegrown" Access-based system stores the account name as the account number (legacy from dial-up days).. I want to import the customers today, but wondered if I could add a varchar column to store the login id into (just temporarily) until I build the services up. I was tempt