sub form question

  • Thread starter Thread starter rmanchu
  • Start date Start date
R

rmanchu

hi

i've got a lot of forms which contains some fields which r identical or
very similar. as the number of such forms are increasing, i'm thinking
of creating a (sub) form with these common fields which would be
embbeded in the 'main' form.

if i do this, then the main form and sub form, BOTH, contain fields
from the same table - ie one form cannot update the table by itself -
which gives an error.

how to solve this? perhaps theres a better way to do this?

thanx
riyaz
 
sounds like the problem may actually begin with your table structure. what
IS your table structure - table names, fields in each table, and how the
tables are related?

hth
 
table t_AbcXyz (AX_RefNo int identity, AX_lastmodified datetime,
AX_OwnerSection int, AX_OwnerPerson int, AX_user int, etc);

table structures something like that.

all field names are prefixed by unique (among tables) chars eg: 'AX_'.

i guess the 3 subsequent fields can be moved to diff table. they are
used for security - eg: users of a particular section r allowed write
access for that record.

ideas?

thanx
riyaz
 
Back
Top