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: <AccessDevelopers@yahoogroups.com> 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 > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/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/
