big problem

[Jim]

Heres the problem

I need a form that will display 4 product class fields that you can selected from
and depending on which option is choosen from the list the companies name,number,fax number appear in a subform on the main form. the 1/2 tables are linked by the ID FIELD which is a primary key field on both more detail

1. Table - Company Detail
FIELD
ID,Company Name,Phone Number,Fax Numbe

2. Table - Supplier Classe
FIELD
ID,Product Class 1,Product Class 2,Product Class 3, Product Class

Table - ProductFilterClasse
FIELD
Products Supplied - are linked to each Product Class Field in the SUPPLIER CLASSES TABLE vary a combo bo
Field List =
Anti-Vibration Mounting
Coil
Fan
Filter
Fixing
Foam Seal & Insulatio
Gas Fired Heater
Metal Fabricatio
Motor
Other
Plate Heat Exchanger
Service
Tool

Problem I am having is when I set the form up I choose from the dropdown list and it shows company names etc, but it changes the information for the first row in TABLE Supplier Classes and won't do anything else I want to be able to choose anyone of the PRODUCTS SUPPLIED from anyone for the 4 PRODUCT CLASS FIELDS and have it display the companies name etc in the sub form

Any help would be great.

 

[John Smith]

Your main form and the controls on it need to be unbound, then they will not
modify the table.

Also you need to normalise your Supplier Classes table or you will find it will
make life very difficult for you. It should contain only one Class column with
multiple rows for each ID.

--
HTH
John

I need a form that will display 4 product class fields that you can selected from:
and depending on which option is choosen from the list the companies

name,number,fax number appear in a subform on the main form. the 1/2 tables are
linked by the ID FIELD which is a primary key field on both more detail:

1. Table - Company Details
FIELDS
ID,Company Name,Phone Number,Fax Number
2. Table - Supplier Classes
FIELDS
ID,Product Class 1,Product Class 2,Product Class 3, Product Class 4
Table - ProductFilterClasses
FIELDS
Products Supplied - are linked to each Product Class Field in the SUPPLIER CLASSES TABLE vary a combo box
Field List =
Anti-Vibration Mountings
Coils
Fans
Filters
Fixings
Foam Seal & Insulation
Gas Fired Heaters
Metal Fabrication
Motors
Others
Plate Heat Exchangers
Services
Tools
Problem I am having is when I set the form up I choose from the dropdown list

and it shows company names etc, but it changes the information for the first
row in TABLE Supplier Classes and won't do anything else I want to be able to
choose anyone of the PRODUCTS SUPPLIED from anyone for the 4 PRODUCT CLASS
FIELDS and have it display the companies name etc in the sub form.