If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem designing a table that pull data from lookup on another ta
Hi, i'm not too familar with Access so please help me out here
i have table 1 with Customer ID + address1 where table 2 with Customer ID + address2 what i want to do is to create a table 3 where column 1 will be fill by lookup list from table 1's Customer ID i wanted to make it so when i choose from the look up list in colum 1 base on the Customer ID it will automatically fill in colum 2 that is the Address 2 in Table 2 with the same ID i am stuck without know how this can be done please tell me how i can make this happen |
#2
|
|||
|
|||
Problem designing a table that pull data from lookup on another ta
What business need are you attempting to solve by putting the two addresses
in two different tables? -- More info, please ... Jeff Boyce Access MVP |
#3
|
|||
|
|||
Problem designing a table that pull data from lookup on anothe
its just an example of the kind of functions i want to achieve..
i didn't designed the original table and there r applications that run dependent on those table already so instead of reorganizing everything i wanna see if there is an easier way to add on top. the original Table 1 holds the customer ID with their main office address where table 2 holds the customer ID with all the branch offices addresses. (more then 1 entry with each customer ID depends on how many branch offices there is) What i need to do is design a 3rd table for RMA department here is the part i can't figure out how it works, i want to make a Form to update the data on table 3, where in the form i can use the customer ID as a lookup and it will automatically list both main address from table 1 and branch office address from table 2 so the RMA guy will input an RMA # then click a button to save it all into table 3 i can't figure out how to set up the text box in the From that when user change the customer ID (drop down list of customer ID lookup). it will automatically update the text box showing both table 1 and table 2 address that is related to that particular customer ID. sorry for the trouble but i'm newbie with access "Jeff Boyce" wrote: What business need are you attempting to solve by putting the two addresses in two different tables? -- More info, please ... Jeff Boyce Access MVP |
#4
|
|||
|
|||
Problem designing a table that pull data from lookup on anothe
If you already have the data existing, spread across two tables, don't
further complicate your design by extracting data and putting into a third table. Use a query to join the data in the two tables, and display in your form. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Repost of Problem with Accessing JOINed Data | Laurie Eaton | Running & Setting Up Queries | 2 | July 29th, 2004 09:56 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Lookup with Data NOT Sorted | Frank Kabel | Worksheet Functions | 4 | March 23rd, 2004 11:16 PM |
Help with Data (Table) below my chart | Jon Peltier | Charts and Charting | 0 | November 20th, 2003 03:36 PM |