Multiple Combo Boxes

[lucour]

Hi,

I work in a Mainframe Operations environment. I have been asked to create a tracking system for the contents of our production batch flow tapes. Each tape contains a unique JobName, Job Code and Job Description. I have setup a table called tblJobInfo and made JobName the Primary key field. What I want to be able to do is to create one form with approx. 3 combo boxes to look as such:

Combo Box Text Field Text Field
Line 1: [JobName] [Job Code] [Description]
Line 2: [JobName2] [Job Code] [Description]
Line 3: [JobName3] [Job Code] [Description]

On each line, in each combo box I will select a different JobName. I want the contents to autofill Job Code and Description. I got it to work for one line by creating a separate Info. table (ie: tblJobA) for each Job Name and then linked it to the JobName master by the JobName field. My form was then based on a query (one to many) of these two tables. I just can't get it to work for multiple lines on the form. I want each selection I make to lookup in a table and autofill its contents, and then store this selection in the table.

Thanks for any help.

 

[Fizzio]

What is the reason for having 3 combo boxes?
Is the tape a physical tape ie type of cassette??
If you are trying to indicate which tape has which jobs, you will need a different Db design. If this is the case, you will need 3 tables, Tapes, Jobs and TapeContents so that one tape can have many jobs and one job can be on many tapes. Plan out what you are wanting to store and why first. Let us know if I'm off base here.

HTH