Form with Updateable and Non-Updateable Recordsource

[dancole42]

So I have a bug tracking database, and I want to create a form that lists active bugs in a datasheet so that users can easily make edits to certain fields without having to open up a form for each bug.

The issue I'm running into is that some of the fields I want to show, but not have users edit, come from aggregate queries, which are not updateable.

For example, there might be three tables:

tBug - Lists bugs
tUsers - Lists users
tBugAction - List timestamps of actions that people in tUsers makes to bugs in tBugs (for example, changing the description, changing the priority, etc.).

So if I wanted the form to show a field like, "Last Change Made by USERNAME," I would create a query called qLastUpdate that GROUPS BY bug_id, and shows the MAX of ChangeDate, then in my form recordsource query I would link it to qLastUpdate WHERE changedate = qLastUpdate.MaxofChangeDate.

The result shows me everything I want to show in my form, but it's not updateable due to it being linked to an aggregate query.

I can forego qLastUpdate entirely and just use Dmax or Dlookup, but that's extremely slow and bad practice.

Any suggestions?

Thanks!

 

[MarkK]

Make the datasheet form a subform child of the tBug form AND the tUser forms. Show navigation, summary and aggregate information on the parent form.
My 2c,