Great, thanks for the info. Ill definitely start working through those tutorials. Hopefully this doesn't take me too long to understand; wish me luck!
Great, thanks for the info. Ill definitely start working through those tutorials. Hopefully this doesn't take me too long to understand; wish me luck!
I am confident you will get the hang. At first it is confusing, but you will understand in no time. Good Luck!
You will definitely want to look at some tutorials. As mentioned, Access is not intuitive. I looked at some of the links provided in post #15. I don't think you can go wrong with the tutorials in the DataPigTechnologies link. However, I do not think I would recommend the other two links. I did not look over all of the tutorials, obviously. I did notice a couple of things I would not recommend, though. For instance, you do not want to use lookup fields. Also, you are talking about developing a business application. I do not think those first two links are for people trying to architect an business solution. I would suggest studying what a relational database is first. You cannot start to design forms until you get the database side first.
The information in post #11 is good advice. Steve is a professional.
You might check out Database Answers Data Models at http://databaseanswers.com/data_models/index.htmIs there a basic Purchase order database template out there that can get me started?
Might not meet your exact needs, but great examples of table designs.