Access Form Question

[Drakkon]

I have three tables the first being person data, second being project data, and third being job data

Project data is based on person and job data is based on project.
There can be multiple projects per person and multiple jobs per project. So in essence one person can have multiple jobs per project.

What I need to do is create a form within access to allow this sort of behavior. Form has to be all in one...let you edit the person...select their project...and edit their jobs on that project. I thought i could just create a listbox of jobs in a subform of the project data in a subform of the person data but it doesn't seem to want to create multiple jobs per project no matter what i try it always keeps the same jobs selected over all projects

Any ideas going on here? am i going to have to start doing some actual coding to achieve this?
I hate access...i would so be done already in php...

 

[KLin]

Originally posted by: Drakkon
I have three tables the first being person data, second being project data, and third being job data

Project data is based on person and job data is based on project.
There can be multiple projects per person and multiple jobs per project. So in essence one person can have multiple jobs per project.

What I need to do is create a form within access to allow this sort of behavior. Form has to be all in one...let you edit the person...select their project...and edit their jobs on that project. I thought i could just create a listbox of jobs in a subform of the project data in a subform of the person data but it doesn't seem to want to create multiple jobs per project no matter what i try it always keeps the same jobs selected over all projects

Any ideas going on here? am i going to have to start doing some actual coding to achieve this?
I hate access...i would so be done already in php...

Is this what you're looking for?

look at frmMain.

 

[Drakkon]

nope...that comes up with the same error actually...index invalid as would generate duplicate key fields

 

[KLin]

Originally posted by: Drakkon
nope...that comes up with the same error actually...index invalid as would generate duplicate key fields

because you want to add projects correct?

 

[KLin]

try this new one


made it a little more user friendly.

 

[Drakkon]

when i go to switch project names the job list does not change...this causes the duplicate value error and bam...this is about where i was at as well...i mean maybe its just me but this seems like it wuld be a common sort of thing to do in a db...and isnt access supposed to make the common things simpler?

 

[KLin]

Well I tried. The only other way I know of would be to separate the employee entry and project entry. Have one form just for entering in employee information, and then have one for entering in new projects(creating, assigning to employees, and creating jobs within said project). My db is the half-assed way to do it

 

[Drakkon]

appreciate the help your on the same track as i was so i know at least other people are thinking like me which is always a good sign.
Now to just find someone thats actually achieved doing this is a form...I'm ready to go crazy here its bugging me so much...