Datasheet view

[GingGangGoo]

Access 2013 Web app

Is it possible to have a datasheet view pull in data from the one side of a relationship and add to the underlying join table. The problem I'm finding is that I set up the datasheet to be based on a query where the two tables are brought in, they become read only. What is a work around for this.
An example of what I mean:
Table - Activities, PK ActivityID
Table - HrsLog with lookup to ActivityID, and field Duration

Datasheet view - want to see all activities (filtered by various criteria) and add hr's to each.

I do not want to add hr's directly to the Activities table, as this is the "one side"

I can totally do this by opening up each and every seperate Activity in a list view, but how clunky and time consuming when I need to add hr's to all activities.

Help please - and btw, I CANNOT use vba in a web app.

 

[JulianKirkness]

I'm pretty certain you can't do what you want - because the datasheet is based on a query.

I think you're best bet is to have a datasheet for entering the HrsLog data with a combo box or autocomplete control for entering the project.