No subject

Okay, just tested it.  When you don't have a duplicate, you refer to the
field in the recordset as just the field name.  When you DO have a
duplicate, I guessed right, you refer to it as tblTable.fldField.

Drew

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com]
Sent: Sunday, January 26, 2003 5:30 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] internal recordset field names


Suppose two tables contain the same field name and you base a recordset on
those two tables and include both fields -- how does the recordset name (or
identify) the two fields? I know I can use As to alias them both, but how
would I refer to these fields within the recordset if I didn't?

Susan H.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd