Hi All,
I am trying to create a relationship and I am at a loss. I don't know VBA... so that isn't going to be a route unfortunately, if that is part of your solution. I send people out on "individual jobs" sort of like contractors! My volunteer management system outputs an Excel spreadsheet with all of my volunteers' contact information. This changes on an ongoing basis.
I want to link this "linked Excel Worksheet" by Member Number (this is the *one* connection) to my Jobs worksheet by member number (and this is the many).
I can't figure out how to get it done so that I can edit directly in a query (which in turn would be a form... where I type in the member number and it populates fields... and I can enter the job details in the same query... I can get it to pull up information in a query, but I can't edit my jobs information in the query....
Any ideas?? I attached some screenshots (ignore the relationship). I want to create a one-to-many relationship from linkedActiveMembers.member_number (one unique record) to the tblDeployments.MemberNumber (many member numbers). I had another forum say I had to do things with Primary Keys and Foreign Keys, but I can't figure out how to set keys on a linked Excel Worksheet....
:banghead:
I am trying to create a relationship and I am at a loss. I don't know VBA... so that isn't going to be a route unfortunately, if that is part of your solution. I send people out on "individual jobs" sort of like contractors! My volunteer management system outputs an Excel spreadsheet with all of my volunteers' contact information. This changes on an ongoing basis.
I want to link this "linked Excel Worksheet" by Member Number (this is the *one* connection) to my Jobs worksheet by member number (and this is the many).
I can't figure out how to get it done so that I can edit directly in a query (which in turn would be a form... where I type in the member number and it populates fields... and I can enter the job details in the same query... I can get it to pull up information in a query, but I can't edit my jobs information in the query....
Any ideas?? I attached some screenshots (ignore the relationship). I want to create a one-to-many relationship from linkedActiveMembers.member_number (one unique record) to the tblDeployments.MemberNumber (many member numbers). I had another forum say I had to do things with Primary Keys and Foreign Keys, but I can't figure out how to set keys on a linked Excel Worksheet....
:banghead: