Adding to Toby's reply; If you have more than one person with the same job description then you would want to place the Job# with the personnel information. If it is one job one person then it really does not matter thought I prefer keeping Job# with personnel information as personnel information is a more of a primary table. The combo box you want would be created from the query which is the data source for your form.
Glenn P. Jones Comm.: 904 823-0653 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Monday, 21 November, 2005 16:05 To: [email protected] Subject: Re: [AccessDevelopers] Two Tables Whether or not to have two tables depends. My guess is that it should be in two tables. For instance, if one person leaves a job and another person takes the job, all you have to change is the personal info and link it to the job table. But then if personal and job info is a one-to-one relationship, you could always have it all in one table and just edit certain fields. In any case, it should be fairly straightforward to create a query that brings the two tables together to base the form on. Create a new query, and in Design view, add both the Personal and Job tables. You will have to store either the Job# in the Personal table or vice versa and then set the two tables to join on these keys in the query. HTH, Toby ----- Original Message ----- From: "Elena" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, November 21, 2005 7:40 AM Subject: [AccessDevelopers] Two Tables > Hello all, > I have two tables: one contains personal info the other contains job > info. I want a form where I can select a person from a combo box and > have their info, from BOTH tables, be displayed. I have tried using a > query using certain criteria but I still can't get it to work. Any > suggestions? Would it be better just to have one table containing all > of the info? > > Thanks. > > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! > Groups Links > > > > > > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
