This may be silly but...I have had trouble in the past with queries where the name of two fields in two different tables were the same. It did not seem to matter whether or not I used table.fieldName or just fieldName. So I started putting the initials of the table name as a prefix to the field name. tableOne.toFieldName tableTwo.ttFieldName.
Did I imagine this problem? I want to redo a database with the naming convetions spelled out in the plum tutorials...have you ever had any problems with identically named fields in different tables? Thanks, Mark Fuqua ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
