an union in accessibility can help you merge facts from two various dining tables

an union in accessibility can help you merge facts from two various dining tables

Each partnership is made from industries in two tables with matching facts. Eg, it’s likely you have a ProductID field in a Products dining table plus in an OrderDetails desk. Each record during the OrderDetails table possess a ProductID that corresponds to an archive in items dining table with similar ProductID.

If you use relevant tables in a question, the connection allows Access figure out which records from each dining table to mix within the outcome put. A relationship can also help avoid lost facts, by keeping deleted facts from getting out of synch, and this refers to called referential ethics.

If your wanting to use affairs, make sure you comprehend the history concepts. For more information, read help guide to table affairs and Get began with table affairs.

In an Access database, you create a dining table connection using the soon after means:

In the affairs window, put the dining tables you want to associate, then pull industry to associate them from a single table to another dining table. Read More