Access Database Problem - Help please!?
Okay, the assignment is to make two tables - one the Renters table, and one the Current Rentals. The information they give me is in an excel spreadsheet. In the example of the book, it states that the Current Rentals table should contain the following fields/>Update:
I am still confused - I have to have a complete table in order make the Query. The table is the issue, maybe I misunderstand your response, but I cannot make any viable information the Primary Key based on the information given, therefore an incomplete table?
Comments
Access Database Problem - Help please?
As you have stated, you can not set two primary keys to the two fields in your post.
You can either combine the two fields and merge together via an update query into a new field on the same table and have this field set as the primary key assuming there is a unique permutation between the two!
You can just Create a new field as the AutoNumber ID which will be the natural candidate for the primary key.
You also need to understand why you want the primary key (and possibly secondary keys) of which using two secondary keys will be an alternative compromise.
To know more about UPDATE queries, see http://www.about-access-databases.com/update-query...
To know more about primary and secondary keys, see http://www.about-access-databases.com/primary-key....
Ben Beitler
Is the opposite laptop strolling the equal or later program? if now not it won't comprehend the 2000/ entry knowledge. Are you definite you're copying the entire database. And how tremendous is the flash force? If the knowledge is higher than the force it's going to drop knowledge as soon as it's complete. Better if the machines are within the equal community to replicate the knowledge around the community making use of shared folders. You will want thehole mdb dossier.
You'll have to make a Query.