Re: DropDownList
- Posted by Irv Mullins <irvm at ellijay.com> Aug 16, 2001
- 428 views
On Thursday 16 August 2001 16:59, George Walters wrote: > > Your program snipit looks like it would work fine if the dropdownlist field > width could be larger than the coded field width. Can't see how to do > this.. The code in the field would be like 'n30' or 'n60' , so the editText > field only should be 3-6 chars but the descriptive text for this could be > much larger (usually about 15). The short code would be used in the DB and > on internal reports, the long on invoices, statements, etc. Why not just leave the descriptive text in the dropdown? If a person chooses "2% 10, Net 30", then that will stay on the screen, but your db could store a code, say: 3, in the terms column. When you later print reports, etc, you can expand that 3 to read anything you want - "10n30", or "2% discount if paid within ten working days, net 30 days from date of invoice". Regards, Irv