Losing the will to live with this one. Tried so many ways and just when i thought I got it, I'm back to square one.
All I want to do is be able to add and show specific data to specific members, but every member will be different.
Basically I have people apply to jobs. them applications are stored in a database "Applications" - I check the applications and then want to present all relevant applications to my clients so when they login and they who's applied to their jobs.
Why am I finding this so hard to do?
If you want members to be able to see who has applied to a job that they have advertised then you will need to make sure that this member has the permission to access and view the uploads from the dataset that you have saved the applications into.
If each member who advertises for a job has their own dataset this will be easier as you can just purely set it up directly for them only.
If you have a dataset that stores all the uploaded/submitted applications for any jobs then you will need to work out a way of separating these job applications into the different jobs, like for example adding a simple id number to the members dataset row entry when they upload their application.
Then you can code your page, so that the member can type in their advertisement id number and it will bring up all the applications for that members advertisement. Or you could setup a simple query on your members page that queries your dataset and only shows the applications relevant to that member.
Yes both of these options above are virtually the same thing, however they can both be setup differently.