Good Afternoon everyone:
I have a database project that I am working on. In its current form it is working correctly, however before I go any further, I want to check and make sure that I have gotten the data laid out in the proper form, and have the proper field types in place, I have had people go over it for me, and I THINK / HOPE that I have managed to catch and correct all the errors that they pointed out, but I would really appreciate it if someone (several someones) could go over it for me and make sure, before I attempt to develop it any more.
The other problem that I am having, is that when I set up some of the data, I didnt/couldnt get the primary key information right, specifically, they needed to be auto numbers specifically:
TblBusinesses - CompanyID_PK
TblCommodities - CommodityID_PK
TblRoads - RoadsID_PK
The problem being that with these not being Auto Number fields, I cannot (as far as I can tell) develop forms to add entries to them. Yes, I can do it in the datasheet view, but thats really clunky. I also know that I can just start over with the bulk data, and if thats the best solution, I will, but if theres a better way, I'd be interested in hearing it
Thanks for your input
TIM
Original Data Original_Data.zip
Current Database SLRG_Waybills_2_1 to send.zip
----EDIT Please note that a post similar to this one was posted on UtterAccess forums in order to cast a wider net and receive additional input /EDIT ----