design table (1 Viewer)

[chanel]

I have 5 tables with the same data (row and columns). How do I make it into a relational table?

 

[*Pete*]

You would need to look for a common Feild in each table and set up relationships between them.

That said, if you have 5 tables with the same data in each are you not defeating the object of a database?

Can you give some more details on what the data is for?

Regards

Pete

 

[chanel]

the table identify the product and its status; the ID of product, location of the product, 2nd ID of product, the status of each product, the time of inspection, etc.; for ex. the time check and if it is pass or not pass.

ex.

[Product ID#]
003UFI9399
...............

[2nd ID#]
RC1234445544
..............

[Location]
GA FEED TO No.34 -RIEEJO
...............

etc......

The tables have the same data in it from table to table, only the status is different. And the difference between it is it breaks into year and quarter. Thus, it has different status from year to year and quarter to quarter.

 

[The_Doc_Man]

1. Add a field to each table that reflects the status.

2. Add your date field that lets you figure out your status changes.

3. Using an append query, add each table to a common table.

In the future, keep the status of the record in the table along with the dates. If you need separate lists based on status, use SELECT queries off the single table.