Teebird
Registered User.
- Local time
- Tomorrow, 07:25
- Joined
- Sep 3, 2006
- Messages
- 60
Hi All
This post also relates to a query but I figure that it all goes back to how my relationships are set up - they are the root of all my problems.
I have set up these relationships in my database - see attached jpg image.
When I make a query adding all the members from the Members table and only the fields BikeNo and BikeDescription from the BikeDetails (1 to many) I only get 6 records in my query - there are 28 in the Member's table. I have no other criteria in the query.
Here is the SQL for the query.
Also you will notice an extra Members 1 table in the relationship - why it is doing this - I have no Members 1 table - Access is creating.
Many thanks for any help / suggestions.
Tee
This post also relates to a query but I figure that it all goes back to how my relationships are set up - they are the root of all my problems.
I have set up these relationships in my database - see attached jpg image.
When I make a query adding all the members from the Members table and only the fields BikeNo and BikeDescription from the BikeDetails (1 to many) I only get 6 records in my query - there are 28 in the Member's table. I have no other criteria in the query.
Here is the SQL for the query.
Also you will notice an extra Members 1 table in the relationship - why it is doing this - I have no Members 1 table - Access is creating.
Many thanks for any help / suggestions.
Tee