Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking data from table to table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking data from table to table
Resolved · Medium Priority · Version 2000
Reply Wed 30 Apr 2008, 15:00Delegate Emma said...
Emma has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Linking data from table to table
I would like to be able to use a drop down box to choose a field but have it related to another column in a different table?
eg.
A Company gets 5%
B Company gets 8%
the above info stored in one table
In another table I'd like to choose B Company and 8% automatically come up or that's the only number shown in the drop down box.
I'm sure this must be possible but not sure how, hope the above details my question well enough!
For upcoming training course dates see: Pricing & availability
RE: Linking data from table to table
Hi Emma
As you probably found out you cannot create a Validation list in Excel that gets gata from another sheet.
In the attached file I used a basic formula to bring the company names from the "Percentages" sheet to the "Calculations" sheet and put them away from the main data.
The in the "Calculations" sheet I created a Data Validation list that takes the names from this list and uses them in the "Company Name" column.
Then I created a VLOOKUP that looks at the value in the "Company Name" column and then goes to the "Percentages" sheet and finds the matching Percentage.
This was combined with an IF statement that keeps the Percentage 0 until a name is placed in the "Company Name" column.
Hope this helps
Carlos
Attached files...
Linking Lists from Two Sheets.xls
|