multiple selection & if values match, show me the list belonging
I have the following situation, where I would need assistance if possible, and there are two parts of this request. Part 1. _I have one table where I have Product names and versions (one product ...
I'm glad you found it helpful! Now for the "Grid Edit" part of my suggestion. Whenever you build a relationship between tables, the report on the parent table that shows the many child records associated with it is what's known as an embedded report. Like any other field, (and report for that matter) you can modify it's properties. If you right click the report, and select "Edit the properties of this form element", You'll have the option to make that report "Editable" from the Parent Record form...
By making the embedded report editable, you are able manipulate/create lines of child records much like you might expect in Excel. (The example below is from the Complete Project Manager app in the Exchange)
As you can see from the screenshot, existing child records can be changed here, and new child records can be added. **Note, as you populate the "empty" lines, new rows will be created to take their place, so don't get the impression from the screenshot that you'd be limited to only 4 "new" records at a time.
