Dear Patricia,

I am not sure if I can ask this here. I have several tables for my new project. I have had several one-many relationships. Somehow there is a relationship between tables which is one-one i guess. I have not created this relationship, may be, access created this automatically since this relationship is trasitive.

When i include the one side table of the relationship my query does not output any recordset. however, i was once able to use these tables for my query recordset.

i want to know whats is the way to resolve this problem. should i use sub query or its possible to use vba and generate the query recordset which inturn would be the recordsource for my form.

thanks in anticipation.

br karthick

__________________
CJBGUY

If the tables are linked by the same field, you will always get a 1-to-1 relationship. Add a different primary key to the right-hand table, to get 1-to-many.

This kind of question (unrelated to the book) should be directed to the appropriate forum. I suggest posting such future questions to the Microsoft product-specific newsgroups. See the following page for instructions on how to connect to the Microsoft newsgroups.

http://www.pacificdb.com.au/MVP/newsgroup.htm

Graham R Seach
Microsoft Access MVP

Dear Graham,

You're right that its not about any specific chapter from the book. However, my question is specifically about VBA.

I am aware of how to create relationship. The problem is this relationship does not appear in the relationship window but appears only the QBE. I have almost completed my project with this bug.

Reg the newsgroup I am unable to connect news.microsoft.com. Outlook express returned the following error.

Configuration:
   Account: news.microsoft.com
   Server: news.microsoft.com
   Protocol: NNTP
   Port: 119
   Secure(SSL): 0
   Code: 800ccc0e

Need your support.

Best Regards
B Karthick

Hi B Karthick,

PMJIH. Actually there are a number of active forums right here in Wrox P2P. Among them is "Access VBA" http://p2p.wrox.com/access-vba-80/

Should you decide to post your question there, I would recommend you be more complete in your description of the problem. Specifically, I would suggest that you provide the SQL statement you are executing that returns no rows.

FWIW, Access will automatically create relationships between tables if you use the "Lookup Wizard..." when you are defining a field in a table. However, without seeing your SQL Statement I cannot say whether this created your problem or not.

Additionally, any relationships that Access may create behind the scenes will not automatically show in the Relationships form. To see all relationships that exist, open the Relationships form and from the menu select "Relationships" then "Show All".

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Dear Graham,

Thank you very much for your patience with me and your prompt reply. My query now returns recordsets but only after deleting the autojoined relationship line.

I guess, I have seen the all relationships, after deleting the join line in the QBE and thats why it did not appear. I will use your reply as the check list for troubleshooting if my query did not work again.

With your help, now I have a completed project. Thanks once again.

Best Regards
B Karthick