Best way to allow updates to a table

  • Thread starter Thread starter karen scheu via AccessMonster.com
  • Start date Start date
K

karen scheu via AccessMonster.com

I have a main orders table that users can not update and another table for
order comments that the user can edit/add. They are joined by order
number. The user wants a quick way to update the order notes. To start,
the comments table will be empty. I would like to create form in datasheet
view, or something like that which contains all orders from the master
table and a join to any order comments from the comments table. If a
comment does not exist, I want empty row to appear and user just enters the
information and it directly updates the comments table. How can I
accomplish this?

Thanks,
Karen
 
Karen,

Make a form based on the Orders table or Master table or whatever it's
called. Set the Allow Edits property of this form to No. Make another
form, in continuous view, based on the Comments table, and place this on
the Orders form as a subform. Set the Link Master Fields and Link Child
Fields properties of the subform to [Order Number]. This should then
behave as you described.
 
Back
Top