display data

  • Thread starter Thread starter mrs
  • Start date Start date
M

mrs

What is the best way to allow a user to view and
manipulate data in the following example:

tblDescrepancy: contains information concerning
descrepancies of a product.

tblDiscription: contains the discription, date,
originator and version of the descrepancy.

I need to be able to have one record in tblDescrepancy to
have many records of tblDiscription. I have set up the
one to many relationship between the two and everything
seems ok. I can open tblDescrepancy and view/add/change
tblDiscription records by pressing the plus sign for each
record.

I can query tblDescrepancy and get several different
tblDescrepancy records for a certain product but it is
not intuitive. I would like to generate a view like the
view in the tblDescrepancy were there is a plus sign I
can click to view/modify/change tblDiscription records.

Can this be done?

thanks

matt
 
Matt,

It is generally very inadvisable to touch the tables in a database for
the purposes of entering/editing/viewing data. You should use forms for
this. In the specific case, make a form based on the tblDescrepancy
table, and a continuous view form based on the tblDescription table, and
put this as a subform on the Descrepancy form.
 
Steve,

Thanks for your reply. I tried subforms but it didn't
give me what I wanted exactly. However, I will search
help for "continuous view form" and see if that leads me
anywhere. Is there any other search words I can look
for?

Thanks,

matt
 
Matt,

With any form, you can look at the Properties and you will see one
called Default View which you can set to Single Form or Continuous
Forms. These correspond to the Columnar and Tabular layout options if
you use the Form Wizard to create your form. A form which is being
designed for use as a subform is often diffferent from the same form for
stand-alone use, in that the field which will be used to link to the
main form does not need to be shown.
 
Back
Top