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.
Datasheet view
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.
