Ways of sending data out for updates

[salamander]

Hi there

We have a list of resources in a table. Each resource has a group (for illustration, let's say 1-10). Each resource is attached to a job which has a start date and end date (in another table)

What we need to do is send out the lists in each group to a group lead. Now this is probably not that difficult (the group numbers are stored in another table so can probably loop through them using a query to dig out the lists). What is starting to perplex me is getting updates back in.

So we could send an excel sheet with the data in it. Let's say it contains:

Name Group Role End Date

They decide to change the End Date. We get the file back in and import it in. If I done that, it would not work as the query is populating from more than 1 table.

How can I use Excel Sheets to update our data based on the fact the data we give them is split across more than 1 table?

Thanks

 

[Dennisk]

I'm working on an identical problem. The solution is to send the primary key of the source record, so your spreadsheet is

PK, Name, group, Rol, End Date

then use the primary key to link the import back to the table for an update.