Nested instances problem

[putte11]

HI !
Making a small project database and is having some problems assigning employees to different tasks.
This is it.
I have an employee table, a project table and a task table.
Now I want to assign an employee as project manager 1proj/1empl working nicely.
Then I want to create tasks in the project 1 proj/many tasks each task assigned to an employee.
I run into trubbel when I try to make a form showing the project with the name of the proj-manager and a subform showing tasks
and the name of the person assigned to the task.
I can do separate forms but as soon as i link them the name is taken by the project.
Do you get it?


Thanks
Putte11

[June7]

No, don't. Want to provide db for analysis? Follow instructions at bottom of my post.

[putte11]

No problems
Its real basic so far to see where Im going. Im just trying to learn this by doing.
Ok I would like the names in the ritningar subform.
As I have alread asked for names in the top form Projekt2 through projekt tbl, I cant reach the names from the ritningar (Drawings) tbl.
I have some swedish letters in there tell me if it causes any problems I can take them away.
There is also a customer (kund) tbl but thats irrelevant.
Thanks Patrik

testdb.zip

[June7]

Kund table seems quite relevant as that is the table with namn, tel data you want to show on form Projnr.
Relationship between Kund and Projnr does not enforce referential integrity. So can there be customers in Kund without a related record in Projnr? Don't use INNER join. Form RecordSource:
SELECT Projnr.*, KUND.namn, KUND.Tel FROM KUND RIGHT JOIN Projnr ON KUND.Kundnr = Projnr.Kundnr;
Set textboxes for namn and tel as Locked Yes, TabStop No.

What names do you need to see in subform? Why?

[putte11]

Sorry language problem there the names are anstallda ( employees)
I need the these guys as project managers and assigned to tasks (ritning= drawings).
Say I assign a project to Janne and give him two drawings to make then I also want to give Patrik a drawing to make in the same project.
Kund are customers to the project 1:1 and works nicely.
And yes I may have a customer without a project.
I just need his record for a smalljob without a projectno.
Patrik

[June7]

Is Ritare the field to store Anstallda ID value? Make the control a combobox.

What is Ritare table for? Think I need translation of table and field names to further advise.

[putte11]

OK I cleaned out most of it and only kept my problem.
I want the projectmanagers name in the box in the Projekt form.
Either I get the name there or in the subform not in both.
Thanks for your time

[rpeare]

testdb-modified.zip

Steps:
1. Changed the query running your form, it didn't include the project manager field from your table
2. Your project manager control was unbound, changed that to a bound field to match the rest of your form and included the project manager field
3. Changed your project manager field to a combo box with the first column being your employee id, the second column being the employee name, hid the first field so only the employee name shows.

[putte11]

Thank you . That gives me a direction to go. Looks simple but I havent figured everything out yet.
Patrik