D
doco
I have half dozen or so tables related many to one to a master table. Many
of these tables share field name such as: Quantity, Value, Category, etc.
(and yes, each table is a unique entity within the db.) In order to
maintain a unique identity for each field I place a prefix before each field
name; which generally is an abreviation of the table name. I then gave a
caption to those field names reflecting their pre-prefix identity.
The problem I have is when making a subform of these tables the prefix
attached field name shows up in the row header and not the caption - which
is absurd! Is there a way besides re-entering the captions in the
properties dialog, to automatically have the caption as the row header on
the form?
TIA
doco
of these tables share field name such as: Quantity, Value, Category, etc.
(and yes, each table is a unique entity within the db.) In order to
maintain a unique identity for each field I place a prefix before each field
name; which generally is an abreviation of the table name. I then gave a
caption to those field names reflecting their pre-prefix identity.
The problem I have is when making a subform of these tables the prefix
attached field name shows up in the row header and not the caption - which
is absurd! Is there a way besides re-entering the captions in the
properties dialog, to automatically have the caption as the row header on
the form?
TIA
doco