richardm55
Registered User.
- Local time
- Today, 08:45
- Joined
- Feb 9, 2014
- Messages
- 28
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:
I made combo controls for field:
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, magazine ID is not selected at all!!!!! and I dont know why.
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
I made combo controls for field:
- Magazine name
- Magazine year
- 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, magazine ID is not selected at all!!!!! and I dont know why.
Last edited: