Hi,
Im new to Access. I just built the tables for a DB of tables that holds 10 years of sales data by product category and tables that holds ten years of external economic data (such as employment rates, housing indexes etc) that is all mostsly monthly data all tables are related to tbldates.
tbldates has a dateID and a column of months beside it. The date ID # 1 of tbldates starts at Jan.1,1996 as the month. (please bear with me this is all going to make sence soon) ...all of my other tables start at 2000 which happens to be date id number 49.
The reason tbldates starts at 1996 is all because of 1 table which is census data of population where the data only comes out every 6 years so I had to have a date ID as far back as 1996 to see any kind of patterns. Other than that all my tables start at 2000. Heres the point! All of the primary keys for my sales data and my other tables start at 49 so of nessesity I did not use Autonumber.
Now I've built a form. (Im new to this remember) I pulled in all the fields I needed. I've never done this before but I did not pull in the date ID feild becasue this wouldn;t mean anything to my data entry clerk. The problem is (becasue I don;t have an autonumber populating as I add new records to the form) ...when I tried to add the latest months data to my sales form it says (primary key cannot contain a null value)
What do I do about this? I s there a way to have my date ID feilds all be primary keys but also start at number 49? Or am I completely thinking about this the wrong way and theres a better solution for this?
Please help