Hi Chris, > Mainly I just would like to know why this stuff is > happening.
It could be a field type or scope problem, or could be related to the type of query you're opening. For example, if you're pulling data from two tables with the same field name in each and trying to bind it only as [fieldname], even though the data is supposed to be the exact same on both, it really is different fields and needs to be bound differently. Unless of course, you're seriously using tables with 70 and 145 fields. Whatever possessed you? Before you consider stuffing all the data you have on any resource into the same table you should really try to see if it *needs* to be all bound to the same table. Usually stuffing all that data into the same table, aside from being a memory waste and space hog in access, results in severely limiting what you can do with it. For example, you have a client and you need to put their address on their information. Do you really want to bind that address to their account directly? Or would it make more sense to have a one-to-many relationship with an addresses table that gives you the option of listing all 6 locations for that business, along with contact information for each? When you need to pull the information out you pull only the information each record needs and don't end up with if statements that are 30 levels into the spaghetti pot trying to figure out if this phone number is full display it otherwise check this one, and this one, and this one... Don't get me started on fax numbers. ;) Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== "Never go to a doctor whose office plants have died." -- Erma Bombeck '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
