Table Structure - Using Query with Form for Input

I am not completely new to Access, but I have run into a road block in trying
to normalize my database. I am not sure if I am using the correct structure
here. I have tried to post a few times without any luck or suggestions. If
you can help, I would appreciate it.

I have 2 tables.

T_Job Info is:
Date Entered
Job Number (autonumber)
Job Name
Contract Type ID
Work Type ID
Estimator ID

T_Bid Results is:
Job Number (long integer)
Contractor ID
Base Bid
Alternate Bid #1
Alternate Bid #2
Alternate Bid #3
Alternate Bid #4

There will be multiple bids for each job number. The problem I have is this.
I am using a form for the user to enter the bid results. The query attached
to the form prompts the user to enter the job number for which they want to
enter bid results. Of course the job number isn’t entered into T_Bid Results.
I have tried to join the two tables, and that hasn’t solved the problem. How
can I copy the job numbers entered into T_Job Info into T_Bid Results. Is
this even the correct way to go about this? I will greatly appreciate any
help/suggestions.

Thanks!!!!!

re: Table Structure - Using Query with Form for Input

T_Job Info is:
Date Entered
Job Number (autonumber)
Job Name
Contract Type ID
Work Type ID
Estimator ID


T_Bid Results is:
Job Number (long integer)
bid ID (autonumber)
Contractor ID
Base Bid

this allows many bids for one job number

job number (1) -> bid (M)

create a form for t_job
create a form for t_bid

drag the t_bid form to the t_job form, creating a subform
link the subform to the form using job number

re: Table Structure - Using Query with Form for Input

Is there a way to set up the form so that I can Enter more than one bid
result at a time instead of opening the form each time I want to enter a new
bid result?

lesperancer@natpro.com wrote:[color=blue]
>T_Job Info is:
>Date Entered
>Job Number (autonumber)
>Job Name
>Contract Type ID
>Work Type ID
>Estimator ID
>
>T_Bid Results is:
>Job Number (long integer)
>bid ID (autonumber)
>Contractor ID
>Base Bid
>
>this allows many bids for one job number
>
>job number (1) -> bid (M)
>
>create a form for t_job
>create a form for t_bid
>
>drag the t_bid form to the t_job form, creating a subform
>link the subform to the form using job number[/color]


--
Message posted via http://www.accessmonster.com