Good morning,
I understand the following question has been asked in different examples, but my Access knowledge is not yet at a standard where I can apply the solutions to my particular problem.
I have to set up a database at work that:
a) Contains all the relevant information about 250 companies, such as addresses, contact details etc.
b) Holds a variety of financial information for each company for various years (eventually this will be for 2009-2020).
So far I have two tables, one called "Company info" with "company name", "address", "contact number" etc, and another with the financial indicators.
However, on the second table, I have three axes, as it were. I have the companies, the financial variables, and the financial years. Do I just allow for multiple records for each company according to the financial year, or is there a better way to do this? If I do allow multiple records, does the primary key for this table become a combination of "Company name" and "Financial year", and if so, how do I link this up to the "company info" table? (I've tried setting a relationship but it says the data types are incompatible.)
Any help would be much appreciated!