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

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -

php - Controller/JToolBar not working in Joomla 2.5 -