Topics Search

Duplicate info in tables Best Practice

Duplicate info in tables Best Practice
Views: 4
I am debating on adding another field to a table in order to track dates. I have the information in another table but these 2 tables have no relationship to each other.

Initially, I was thinking of creating a relationship between the two tables in order to pull the date from there. But this table will not always be filled out depending on the employee class.

So, I was thinking of just adding the field rather than creating a relationship as I don't always need the info in that table.

I am wondering before I go and add the extra work, would this be the most efficient way of doing this?
Sponsored Links:

More topics

 

Duplicates Showing

Preview
Problem I have with my queries is beyond my reasoning. For starters I have 5 tables. With the 4 tables I have a primary key. Each Primary key is in a one to-many-relationship. The last one is not important at the moment.

I have a query that pulls certain information from each field an of course the primary keys are linked and that’s how it know what info to pull from each table.

My problem is in the query it certain records will duplicate. Certain records will duplicate 6 times while others 4 and so on. Other records on the other hand to not duplicate at all.
 

duplicate tables in relationship view

Preview
and to Access having just finished my first book on it. I have created my own practice database based on my own work location, with several tables including employee, department, and computers. One of the relationships is a one-to-many relationship between the employee.deptID field and deptartment.ID(pri-key). In the relationship view, I now show two relationships for this one. One, the original, and a second one between employee.deptID and department_1.ID which is a duplicate of department. It doesn't seem to hurt anything but I was curious why there are now two of the same relationship ? And what made the duplicate department_1 table show up ?
I don't remember the duplicate table being there when I created the relationship
 

Improving my Database

Preview
In my dabtabse there is several tables such as one with duplicaes, one with out, other peoples info etc etc.

Everytime I need to add something I have to add it to each one individually, and was wondering if I could enter it one place, and it would automaticaally go into all tables?

Also if this is the case, if I were to add a set of data to my non duplicates table, and if the duplicate is already in there, is there a way where it stops me, so I dont put the duplicate in, as it would save a lot of time looking throught my databse checking if I already have this data
 

Copying records

Preview
I have searched for a method of copying records.

Is there a way to enter of a person's info once into a form and then create a macro to copy/save to/save as/duplicate the info into two or three tables?

I can only find the copy command for a whole object, such as a complete form, in the macro options.)

I don't suppose there is anyway a bound control can have two sources?

The data I need to enter requires two or three different name titles in two or three different tables, but the other info of course is the same (e.g. place of birth, DOB, parents, age, etc.).
 

join tables with duplicate records ??

Preview
How can I remove the duplicate records with the below 2 tables?

S/No 105 and 107 export to excel sheet are duplicate .
 

Importing an Excel sheet - want two tables out of it

Preview
I'm building a database - first one in 12 years. I am importing into Access 2010 from Excel 2010. This will be a simple contact manager database. I will have three tables: Practice, Contact, and Notes.

I would like to split the Excel sheet into two of those tables (Practice and Contact). I will link those tables by the AutoNum of the Practice table (PracticeID) into the field of the same name in Contact.

How do I go about bringing in the data so it works? Should I take the autonumbers from the first table and copy/paste onto the Contact table?
 

Access 2010 Duplicate function

Preview
I am trying to duplicate a form with several subforms using the built in Duplicate button. However, I am getting Paste Errors.

I presume there is no easy way to duplicate a record this way?

The form is based on a single table but that table has Foreign keys in 5 other tables
 

10 plus tables to join

Preview
I have 10 + tables that I need to join together Easy when they have info in them, but sometimes info will only be in 1 table or 2,3,4 etc.

I can force an entry into each table - but that seems a bit crude (I.e add a record for every new entry in my main table into the 10 child tables - but this seems to be a waste - I only want to join tables when there is info in them - when I am doing this I can join two tables fine - but adding another one where there is no data FK seems to throw it. I will have about 10-12 tables to join.
 

Join tables with duplicate records ??

Preview
How can I remove the duplicate records with 2 join tables?

S/No 105 and 107 exported to excel sheet are duplicate
 

Create a Query in Microsoft Access to Find Duplicate Entries in a Table

Preview
There are many causes for duplicate data: for instance if you have multiple users entering data simultaneously via linked tables, or you might inherit a table with duplicate data already entered.
Running into duplicate data in an Access Database can be quite annoying during the hectic workday, so I decided to write up a technique to help identify the duplicate records so you can manually handle them.