MS-Access, form that adds info to a one to many relationship -
i have access table orders , sub-table itemid's. has 1 many relationship.
i want create form adds itemid's selected order(already existing).
this how expect like:
order: [ ] itemid: [ ] measurement1: [ ] measurement2: [ ] [save-button] can me this?
subforms politically correct way go if want users have access order screen. if users not need access order details directly, items, put combo-box
order: [ [v]] which has control source query order id in orders table. link orders field in item table , store order subform would, without letting user see details of order.
however, if want multiple items shown selected order, use subforms (having subform multiple-item)
Comments
Post a Comment