Forum Discussion
info from pulldown menu and store it in another table
Hi All, Who can help me? I made a master table in access with 6 headers in it, like below Another table has my customers in it, with company nr, company name, address, zipcode, place, and country,...
If I understand correctly, you are attempting to duplicate information from the customer table into the "mastertable". As arnel_gp already pointed out, that's not how relational databases work.
Please invest some time learning about the process of normalization for databases.
The tables in a relational database application are designed so that you can store each data point one time, in one place, in one table. The "relational" part is the method by which records in different tables can be linked so that the data is available without being duplicated.
An internet search will turn up dozens of references, but here's one to get you started.
https://database.guide/what-is-normalization/