Data entry into multiple tables same field name

[mpaulbattle]

Not sure if this is on the forum, but I did not see what I am about to ask.



I have two tables one called Providers and one called MU. Both tables have a field called Providers.

I would like when I enter the name of the provider on the Providers table to automatically insert the same name into the MU table.

Is that possible? Please help.

[orange]

Probably. Perhaps you could tell us more about WHAT you are dealing with before asking HOW it might be solved.
We need to know WHAT before we can provide focused responses.

Providers and MU doesn't tell us much.

[mpaulbattle]

Orange...the table Providers house the names of doctors and their demographics. The table house where those doctors are currently at in the efforts to provide quality care. Both tables have the fields Providers (their name), NPI, and Practice (where they work). I am trying to get it to where if they enter the doctor's name in the Providers table, when I open the MU table the doctors name is populated in the Providers field in that table. We're trying to stop the user from having to enter the same information twice. I'm new to Access and have been reading and watching videos, so I hope this answers your question.

[orange]

Show us your relationships window as a jpg.
It appears you may have a table structure issue. You wouldn't enter the same data into both(several) tables.
The secret is to get your tables set up to meet your business rules. And to do that efficiently you really need a clear description of the issue you are tryig to support with your database.

doctors are currently at in the efforts to provide quality care.

Doctors
efforts
quality care
"to whom" (patients/victims???)

[mpaulbattle]

This is what I have so far.

[orange]

I think you are missing the point. What is the subject matter you are dealing with?

A few comments for consideration:
Tell us in plain English what an MPL is? Readers don't know your business and are trying to understand WHAT he issue is.
MUByProvider doesn't clarify anything.

You'll have more success with Access and vba if you use names that DO NOT CONTAIN EMBEDDED SPACES.

Do some research on Normalization, Primary Key, Foreign Key, Data model/ERD

[mpaulbattle]

Orange...I guess it didn't take my edit under the jpg.

Subject Matter: I am assuming you're asking why and what I am trying to do. At the moment we have three excel spreadsheets where our Implementation team has to add, edit, or update every time they make a change to a practice/client. Unfortunately, they have to update all three spreadsheets which sometimes they forget. They asked if we can put it into Access so it can update across the board without them having to open all the spreadsheets.

The MPL, Master Practice List, is the information regarding the practice. It has everything about the practice from the name, phone number, address, modules they work with, etc. Strictly about the practice.

The MUbyProvider table captures the doctors progress in their efforts to provide quality care patients. They have stages they need to complete in order to complete the program.

They want to know if the Implementation team adds a provider to the Providers table, can that be populated onto the MUbyProvider table so the MU team does not have to add it?

I hope I have given you what you need. Thanks for being patient with me.