D
Database Diva
I have a form to capture data about rental properties - each record has it's
own Autonumber ID and also an administrative code which is alpha-numeric.
This alpha numeric field is integral to the relationships between the various
tables. My client has advised me that this field is not appearing correctly
in certain reports. In the form being used for data entry the property
profile admin number is correct, however in the report is reflecting another
property profile admin number. My copy of the database is fine and the data
is all OK. Any ideas about what could be causing the data to "jumble".
own Autonumber ID and also an administrative code which is alpha-numeric.
This alpha numeric field is integral to the relationships between the various
tables. My client has advised me that this field is not appearing correctly
in certain reports. In the form being used for data entry the property
profile admin number is correct, however in the report is reflecting another
property profile admin number. My copy of the database is fine and the data
is all OK. Any ideas about what could be causing the data to "jumble".