what is the best way to handle multiple record entry on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tried several time to conquer this problem. I am not new to Access
but not am nowhere near an advanced user. Any help is appreciated.

I have two tables

T_Job Info
Job Number (autonumber)
Job Name
Bid ID
Estimator ID
Contract ID

T_Bid Results
Bid ID
Contractor ID
Base Bid
Alternate Bid #1
Alternate Bid #2

Each job will have multiple bid results. What is the best way to set up a
form that would allow the user to enter each of the multiple results on one
form. Each attempt I have made has failed. I have used multiple subforms
but when I enter info into the first subform, each additional subform is
populated with that same info. It was suggested that I use a continuous form
but I have never used those and could not find much info on it.

Again, any help is appreciated.
 
Back
Top