Relations not getting right

And when you do this what happens?
SELECT Werk.projectid, Projecten.Projectnaam
FROM Werk LEFT JOIN Projecten ON Werk.Projectid = Projecten.projectid ;
 
Do you have any valid ProjectID's in the ProjectID field of the Werk table?
 
Oke got some output now, I manually entered projectid in Werk table.
Now how do I get those projectid's in Werk table by using the form??
 
Still it's not oke..
When I remove all werk records, No projectnames are shown on the form..
Im going to cry for a while..
 
Still it's not oke..
When I remove all werk records, No projectnames are shown on the form..
Im going to cry for a while..
That is exactly how I would expect it to work.
 
Oke, but when I start using this, there are no werk records, so how would I write hours on a project if I can't select it?

Would this be your choice of design?
In other words: do you have tips for this db?

(Are you fed up with me already?)
 
How about posting your db again and we'll take a look at it.
 
Your forms are still bound to tables instead of queries. Based on your Werk or Projecten forms, I have no idea how you want these forms to function.
 
Maybe you can show me a way that they are functional??
 
If I were you I would start with one of the available Templates that come with Access or are on the MS Office site. Even the NorthWind example that ships with Access shows a decent user interface.
 
Oke,
Thanks for your time and patience with me
 

Users who are viewing this thread

Back
Top Bottom