DWUTKA at marlow.com
DWUTKA at marlow.com
Sat Feb 21 15:04:33 CST 2004
Ya, but that leads to 'fixing' the number of questions to 25, unless you make table design changes. The original question asked for an approach where size would be smaller, and no table changes would be needed in the future. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com To: Access Developers discussion and problem solving Sent: 2/21/04 4:30 AM Subject: RE: [AccessD] Table Structure questions On 20 Feb 2004 at 18:25, DWUTKA at marlow.com wrote: > Sorry, use 97 for almost all of my backends....so I keep forgetting about > the Unicode issue! <grin> > > However, what are you LINKING the records in that table with? Each record, > in a one per question table, would need a caller ID (Long), Question Number > (could be byte), then the answer (another byte). > > Now you have 6 bytes per answer (instead of 1 in ASCII, or 2 in Unicode!) > No, I agreed completely with your idea of storing all the answers in one record, I just suggested stotring the anwers in separate fields rather than a string - so you have CallerID plus 25 byte fields rather than CallerID plus one string field storing 25 characters. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com