Evening ladies and gentlemen.
New to both the forums and access, but despite both, I have a bit of a project. <grin>
I need to make a bilingual database for maintaining and retrieving business segment and product names for stock reports. Though the db will be mostly static and updated only periodically, I am at a bit of a loss as to how best to break down the tables for what I want to do (ultimate, design a search function). In summary:
I have a list of analysts who's contact information I would like to maintain.
Each analyst covers a specific number of stocks. One or two analysts will cover a number of stocks (a many-to-many relationship?)
Each stock has a ticker unique ticker number (our likely primary key), an official company name in two languages.
The most important bit is the following: each stock also has a bilingual list of business segments I'd like to record in two languages as well.
I guess I'm just a bit flummoxed and don't know where to begin. Essentially, I'd like a relational DB based on the above where I can:
Input a ticker number and have access retrieve:
The relevant analysts and their contact information
The business associated with the ticker number and its two official names.
The business segments (again, two languages) associated with company (and by extension, ticker number).
Any tips as to how to begin? (other than having massive excel spreadsheets of all this info, of course)
Much obliged!
Rattykins