Please post the SQL of the query you are trying to use to perform the search.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: vip2442_access [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 22, 2005 11:16 AM > To: ms_access@yahoogroups.com > Subject: [ms_access] Help (Searching in realation one to many) > > > > > Hi > > I have A Realtion 1 to Many and i want to search using the one but i > got only the information the i search for if it in the all tables if > it in one table i got nothing? > > i tried to delete the realtion > but i got the information repeat in the result? > > this is the realtion > http://lonelymoon2442.jeeran.com/Auth.JPG > > > > > > > Yahoo! Groups Links > > > > > > 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/
