Problem with combo control

[richardm55]

I've created simple base with 2 table related each other. Then I've built query with the fields taken from both tables and finally I've made the form with some combo controls.
There are 2 tables:

• Table articles with following fields:

• ID (main key), article
  
• Article name
  
• Article type
  
• First page
  
• Last page
  
  
  
• Description
  
• ID magazine
• Table magazines with following fields:
  
  • ID magazine
  • Magazine name
  • Magazine year
  • Magazine month
  
  

Both table are related through key ID magazine
I made combo controls for field:

• Magazine name
  
• Magazine year
  
• Magazine month

I've created some records for table magazines for diffirent magazine names and various years and months asigning their main key as number (not autonumber, otherwise table will created the same records for the same value of 3 fields: magazine name, magazine year and magazine month.

I have problem when I start using the form. When I select values in 3 combo controls (taken from coresponding fields from table): magazine name, magazine year and magazine month, ID magazine is not selected at all!!!!! and I don't know why.

That's shame nobody is not able to give me any clue, yet but I will be patient to get proper solution.

[orange]

Please read this on cross posting. Cross posting etiquette.

[richardm55]

I think I have found myself the solution and my data base works like I wanted. Here is link into another forum where I've described it with details Here is link http://www.access-programmers.co.uk/...31#post1438531

I still have a little problem. As data source for combo box controls I take records from some fields of Magazine table, Magazine Name, Magazine Year and Magazine Month and those combo boxes unfortunately display couples the same values. So my question is how to write rule in query used for combo boxes to list uniques values only without repetitions?

[Missinglinq]

I'm a little fuzzy, vis-à-vis exactly what you want to be unique, whether a single Field or an entire Record, but you can modify the SQL Statement for the RowSource for the Combobox to work either way.

(Directly from Access Help)

DISTINCT

For eliminating duplicates of specific Fields: Omits records that contain duplicate data in the selected fields. To be included in the results of the query, the values for each field listed in the SELECT statement must be unique. For example, several employees listed in an Employees table may have the same last name. If two records contain Smith in the LastName field, the following SQL statement returns only one record that contains Smith:

SELECT DISTINCT
LastName
FROM Employees;

DISTINCTROW

For eliminating duplicates of entire Records: Omits data based on entire duplicate records, not just duplicate fields. For example, you could create a query that joins the Customers and Orders tables on the CustomerID field. The Customers table contains no duplicate CustomerID fields, but the Orders table does because each customer can have many orders. The following SQL statement shows how you can use DISTINCTROW to produce a list of companies that have at least one order but without any details about those orders:

SELECT DISTINCTROW CompanyName
FROM Customers INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
ORDER BY CompanyName

Linq ;0)>

[June7]

Topic also addressed in https://www.accessforums.net/forms/u...ist-53578.html