Chuganaught:
+ You'll do basically the same thing at the query or form level that you're doing in Excel. However, we have precious little information about he overall design of your database; thus, it's almost impossible to point you in the right direction.
>> NORMALLY, avoid doing this at the table level unless you are going to be publishing the database to a sharepoint site. Lookup fields at the table level can create a lot of difficulties for you in the future!
> We do not need a copy of your Database attached. In fact, many of our experts (me too) are not able to usually open these attachments for various reasons.
Instead, please just type the information in to a normal post and format it using the
[CODE/] button found in the post toolbar. A recent example of what we're look for is here:
Sum Across Columns in Crosstab
Use the
[CODE/] format for posted VBA, SQL, Scripts, and Formatted Tables. It will insert a
[code] [/code] tags around your selected text.
In tables use spaces not tabs to align your data. :)
+ I'll also PM you a copy of my resources for new Access designers. Please check your Bytes.com inbox at the top of this page. :)
+ One of the entries in the PM is a link to a tutorial that will provide you a hands-on learning experience covering most of the basic skills you'll need to get up and running.
+ Normalization is usually your best friend, there are also entries in the resources I've PM'd you for two articles covering this concept. It is VERY important to master this concept... doing so will make a lot of your tasks,
for example the one you've asked about, so much easier to accomplish!
+ Finally (this link is the PM too) look at the bottom of this page, the VBA Insights Sitemap will send you to a set of documents covering a lot of common tasks and questions. If you will take a few minutes to read the titles I'm sure you will find a lot of useful information. >> If you have any questions about something in these documents, please start a new thread with that question as we try to keep the articles strictly related to their content.