How to manage a notes table with a weekly imported main table?

[kbay808]

I have a main table that is imported weekly from another Access DB which I have no control of. I also have a new table with a notes field and a product ID field. The issue is the product ID field in the main table is constantly growing. When I created a query with all of the fields from the main table and the notes field from the notes table I could not enter any data into the notes field unless the product ID was already listed in the notes table. Is there a way to make a query update the notes table or a macro to add the missing product IDs from the main table to the notes table?

[orange]

You should research Normalization and 1 to Many Relationships. Your issues seem to be related to some basic concepts/principles of database.

The 1 to many is similar to Parents and Children. Before you can add a Child, you need to have a Parent.

In your case you can not add a Note to a Product unless the Product already exists.

You might get a lot of "quick info/experience" by working through the tutorial at
http://www.rogersaccesslibrary.com/T...lationship.zip

It starts with some business rules/facts, creates some tables, does Normalization; then creates Relationsghips leadin to a properly structured database. Try it -- you'll learn a lot of the concepts that apply to your current issue.
Good luck.

[kbay808]

Thanks for the info

[orange]

Sooner or later you will meet up with this general approach. Better to get into it with a real issue in order to focus.
Good luck.