Re: [AccessDevelopers] Re: Merging data from two tables onto one form

[Toby Bierly]

You've got to build a form first before you can create a look up button for it, and it doesn't look like you've figured out how to create a query that pulls from 2 tables and then created a form based on that yet.   FIRST THING TO DO is create a query, add the two tables that you want to pull from, add the fields from both the tables that you want, and keep playing until you get the query you want.  It should select the information that you want to display in the form.   And even before you do this, you must have your table structure well defined and either have your relationships already set up, or know how you want to join the two tables.   Asking questions like "How do I create a form from two tables?" and "How do I create a Lookup button" are SO general that no one is going to be able to answer those questions very well, even if they were willing to write an step by step how to.   Start with the table structure and creating a query to base your form on -- that's square one -- and then come back with specific questions when you hit bumps in the road.   Thanks, Toby ----- Original Message ----- From: maurice hall To: AccessDevelopers@yahoogroups.com Sent: Wednesday, November 16, 2005 12:03 PM Subject: Re: [AccessDevelopers] Re: Merging data from two tables onto one form ok,,,thanks,,,how do create a look up button,,,, to find records.. maurice torres0157 <[EMAIL PROTECTED]> wrote: First you, must create a query using the two tables and selecting fields or creating calculated fields. You need to create a key for both tables. then create your form from the query. simple A.T. --- In AccessDevelopers@yahoogroups.com, "bigmaur_1999" <[EMAIL PROTECTED]> wrote: > > I would like to know how to merging data from two tables onto > one form, I read the book and still don't get it.??? > can someone help,, > e-mail me at [EMAIL PROTECTED] > SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access training Microsoft access training course Microsoft access programming Microsoft access tutorial Yahoo! FareChase - Search multiple travel sites in one click. Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access training Microsoft access training course Microsoft access programming Microsoft access tutorial YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.