Tables and a form

[Apar via AccessMonster.com]

Hi,
I'm new to MS Access and I have been given this project to work on.
I have 2 tables and a form
Job Type: Job Name, Job Type ID (primary Key), Job Title and so forth..
JobEvent: Job Name,Job Event ID(Primary Key), JobType ID(Foreign Key), Job
Title and other parameters

The form is based on the query from the above 2 tables. This form contains a
combobox (Job Type ID) whose row source is the query. Each job may have more
than one job ID assigned at a time. For example,

Job# JobName JobDescription
01 APa Chett

Parameter#1 Parmeter Des1 Parameter Value1
01 Term Code 200502

I might have the same job listed again but with a different term code value
"200506".

Hope this makes sense..Thanks alot in Advance.

 

[Allan Murphy]

What is your question?

 

[Apar via AccessMonster.com]

Sorry about that..I want to select a job ID from the combo box and assign a
Job number(could be more than one) and should be able to change the parameter
values for each particular job.

Thanks
Apar

What is your question?

--
Allan Murphy
Email: (e-mail address removed)

Hi,
I'm new to MS Access and I have been given this project to work on.

[quoted text clipped - 17 lines]

Hope this makes sense..Thanks alot in Advance.