You must make a query based on the two tables. Then link the query to the form.
Use query-wizard. The query you then is make should be linked together with one of the variables that is simular. So if you have a table of all the Orders, one of the Variables will be a custommers ID that was making this order. Then simply link this Order-Custommer- ID to the ID-nr of your other Custommer table. You do this by pointing with the mouse, hold the left mouse button down, and lift the variable to the simular Variable on the Custommer table. An arrow will indicate the link. (If you then right-click on the arrow, the joint property of the link will show up. Use the nr 2 link, so if you have bad info in your table, you will see the Reckord anyway VARY IMPORTENT, ALWAYS DO THIS) If you do this right, then every time you look at this order, you also have access to the custommer information. This is importen stuff to lear. You must make this work. This Query linking is also nice to use on a list. OK? Stein (sorry, about some bad english.) --- In [email protected], "masuma_tumpa" <[EMAIL PROTECTED]> wrote: > Thanks Leo, its nice work. > > > I have another important question, how I will connect two table with > one form (MS Access). So that I can show one table data in the form > and after modification I want to save the data plus some text box > data to another table. > > Thanks in advance. > > Masuma > > > > > > > > > > --- In [email protected] , Slimey Hom > <[EMAIL PROTECTED]> wrote: > > masuma, > > > > try use recordsetclone. See example below: > > > > > > me.recordsetclone.findfirst "IDNdx = " & yourIDVariable > > me.bookmark = me.recordsetclone.bookmark > > > > Remember: > > 1. Make sure that your form is bound to the table you want to > search. > > 2. make sure that IDNdx is you primary key on that table. > > 3. All your text boxes or other objects are bound to certain field > on that table (for you to view the result) > > 4. to test the code, put it in a command button having a Click > event. then either the yourIDVariable came from a text box or from > inputbox... > > 5. try it and you can navigate anywhere in your table by using ID > key. > > > > eNJOY!!! > > > > > > > > ---->>> "mABuHaY AnG pInOy!!!...!!!" <<<----- > > > > > > > > > > > > masuma_tumpa <[EMAIL PROTECTED]> wrote:Hello all, > > > > Can any body help me? Say I have 1000 record in my table. Now I > want > > to display in my form the 150th record or I want to show the > record by > > specific id no/name. Please let me know the configure and code > (VB) in > > Access. > > > > Thanks in advance > > > > Masuma Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> 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/
