Hi Joe, In your client table, you need to have the client data id as your primary key. In your incident table you need to have a field called client data id and have it as a foreign key. You also need to create a one-to-many relationship between the client data id in each table. You could then create a query that takes both of these tables. On the client table bring down all of the fields that you need and on the incident table bring down the client data id and enter the following in the criteria: Is Null. This should display all of the clients that do not have any incidents. You could then create a form based on this query if you wish. Hope this helps. Jose "When you come to a fork in the road, take it." - Yogi Berra -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Tuesday, September 27, 2005 11:03 AM To: [email protected] Subject: [ms_access] Need help with a form using two tables....Only one with data??? Hi,
I'm try to create a query using two tables: 1.Client 2.Incident The client table has typical client data Id, Name, DOB etc.. The incident table will add "incident data" to a client since one client can have many incidents. The problem I am having is, when I create the query it shows no data at all, I would like it to show the client data with no incident data, which will be added in a form... I hope this makes sense to someone.... Any help/samples or places to look would be great!! Thanks In Advance Joe + _____ YAHOO! GROUPS LINKS * Visit your group "ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
