Form with subform datasheet Help

[flavioso]

Hello:

I am new to access and have a question to see if someone can point me in the right direction. Currently, I have created the tables and have created the relationships as shown in the picture before.

The goal of the database is to create a form where the user selects a year, selects the customer, and then the oem/end user. Once they have chosen these 3 values, they are able to enter into a datasheet subform; the part number, price, discount value, terms, etc.

The order should be Year --> Customer --> End User

Should I create 1 form with 3 lookups, and then the datasheet tied to the end user, or is there a way to tie to all 3? Each year, the data may change for the quote, so I need to start with the year, unless someone knows and easier way.

My question is how do I link the year, customer and oem/end user to one datasheet with data?

I appreciate any help in advance,

brad

 

[ajetrumpet]

My question is how do I link the year, customer and oem/end user to one datasheet with data?

Those 3 fields are already linked by your relationships. If you want to see them all in one datasheet, create a query with 2 INNER JOINS that bring your 3 tables together, and set the RS of the subform to it, and the default view of the sub to "datasheet". Is this maybe what you need?