Well thank YOU for taking the time to leave such a positive and encouraging comment. Sincere gratitude is highly underrated!! :)

I agree. Your videos are a fantastic resource for those of us who are just starting out. Thank you very much for taking the time out of your day to put these together!

Great to hear!

Thank you! See all of my KZfaqs organized at learncs.w3spaces.com

You're very welcome!

Tysm. See all of my KZfaqs organized at learncs.w3spaces.com

I just started a new playlist based on the northwind database!

See all my youtubes organized at learncs.w3spaces.com/

Welcome!

Thanks for the nice comment!! See all of my KZfaqs organized at learncs.w3spaces.com

You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/

@@lfriedrichsen Okay

Thanks! This web page tells you how to download the Northwind database through the templates feature. learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases

Ty! See all of my KZfaqs organized at learncs.w3spaces.com

Thanks

You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/

You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/

Very observant! The fields used in a one-to-many relationship do not have to have the same field name as you pointed out. It is common to give them the same name, but not technically required.

@@lfriedrichsen Oh ok that’s very cool. Thank you for sharing your knowledge!

I was about to ask :) thanks

You are welcome! See a listing of all of my KZfaqs at learncs.w3spaces.com

You're welcome! You can find all of my KZfaqs organized at learncs.w3spaces.com/

Subdatasheets show the "many" records related to "one" record in the table you are viewing in Table Datasheet View. So only the table on the "one" side of the relationship will have the ability to show a subdatasheet.

If you're getting the "Insert Subdatasheet" dialog box it means that you're viewing a table on the "one" side of a "one-to-many" relationship to more than one other table...so you have to choose which table's records to view in the subdatasheet.

thank you for replying

No. If two tables have a many-to-many relationship then you model that with a junction table that is on the MANY side of a 1-to-many relationship with the two original tables in a many-to-many relationship. Go to the 4:12 minute mark in this KZfaq to see how many-to-many relationships are resolved with a junction table. Products and Orders have a many-to-many relationship that is resolved with the Order Details table. One product can be ordered many times and one order can have many products. Note that the Order Details table is on the MANY side of the relationship to both Products and Orders. Another example is the Customers and Shippers tables. They too have a many-to-many relationship that is resolved with their one-to-many relationships to the common Orders table.

You'll need a Sales table with a field for the actual price per sale. Customers table has a one-to-many with Sales. Inventory table has a one-to-many with Sales. And you can even have a suggested/regular sales price field in the Inventory table. But the Sales table must have a field to record the actual price given you're telling me that the price may be different for each sale.

My KZfaqs on table relationships should be of value here. All of my KZfaqs are organized at learncs.w3spaces.com

If it's a short question that I can answer here, I will.

www.microsoft.com/en-us/microsoft-365/access/?rtc=1

You can pause it, rewind it, or watch it over again. You are in control of the pace.

Ty! All of my videos are organized at learncs.w3spaces.com