bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 734
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have situation where we have an ongoing survey where the survey file needs to be merged with a master member table to bring over certain fields (age, gender, ethnicity, political affiliation) in the survey table for analysis.
I tried to create a one to many relationship in Access and PQ but there is something in the master table data that just creates an outer join (essentially creating a many to many relationship). I have to use a Index and match formula to bring over these fields into the survey table. I was thinking of creating a merge in PQ automatically? I'm developing a process for our admins and field reps so I"m trying to keep the process as simple as possible.
The tables would have to be updated weekly or daily so it will need to be updated quite often.
Can PQ automatically updated merged tables like appended tables providing the tables structure doesn't change?
Thank you for your help in advance.
Michael
I tried to create a one to many relationship in Access and PQ but there is something in the master table data that just creates an outer join (essentially creating a many to many relationship). I have to use a Index and match formula to bring over these fields into the survey table. I was thinking of creating a merge in PQ automatically? I'm developing a process for our admins and field reps so I"m trying to keep the process as simple as possible.
The tables would have to be updated weekly or daily so it will need to be updated quite often.
Can PQ automatically updated merged tables like appended tables providing the tables structure doesn't change?
Thank you for your help in advance.
Michael
