Recent content by moto485

The Primary Foreign Key (PF) are foreign keys made part of a composite primary key. I thought PF was something unique to MSSQL but it turned out learning about it was a real waste of my time :banghead: Thanks for you help I will go with MySQL since I already know that :) Thanks.

haha no problems Bill glad I could help :)

Try right clicking on the fields and selecting "Unhide Fields"

I would go with MySQL (which I already know) and Access but I thought they might not play together as well as MSSQL but if you have used MySQL with Access and had no problems then I might change my mind and go with that?? I have tried myself and it seemed to work well but haven't put it into...

yes if you want to modify the front end that is written in .net you will have to edit the code (unless they have built in features) and you can't just edit it like php you have to recompile it when you make changes, it is a big framework and if it is written using the mvc pattern there will be a...

well it is going to get quite big but will start small and workup over this year, so Access will okay at the very start but will out grow and security will be better with mssql plus I can create apps in php for guys on the road.. my database skills are not up with my php but you gotta start...

Thanks, I think i need to do a lot more reading on MSSQL databases.. Regarding the naming conventions because I am going to be building a much larger system I did the following in the ERD.... Employee database would have "em" appended to the table and attributes that way emAddress (employee)...

Hi I am still learning this ERD stuff and am trying out DeZign for a MSSQL database and I thought I had PK and FK all figured out now im am reading about PF and trying to understand. Reading about identifying I thought the CL_Address table should just have the "PK clAddressID" and "PF...

I think you are just wanting to know if you can automate these processes rather than enter the data manually? if I understand then you will need to read up on some VBA code..

It does not automatically download it like you would expect you have to download and install it yourself. Download http://www.microsoft.com/en-au/download/details.aspx?id=4438

Amazing! Just going through a test run of a few thousand and looks to be perfect! You guys are wizards! Thanks

Thanks for this code it works but for some reason didn't work for numbers like 1.9872 and 2.6784 and 7.8732 :(

Hi I am increasing prices and after increasing I am left with 4 decimal places and am trying to figure out how to run an UPDATE query to round down prices to the nearest 5 cents, examples below: 42.4516 round to $42.45 42.4659 round to $42.45 42.4489 round to $42.40 2.49 round to $2.45 2.46...

at the moment your usual excel sheets :) Some of these db exist others will be created later on. I am currently doing a rough er diagram of everything and then i'll focus on a detailed er diagram for People, Assets, Training databases. I was going to start of with those 3 and build from...

Just wondering would it be best to put the following in 4 separate databases? i would think so but thought id ask.. Assets (including equipment, vehicles, testing equipment, equip. tracking, etc) Training (certificates, yearly training, staff training, etc) People & Suppliers (all the usual you...