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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Joined Tables 1
Multiple Subforms 3
Is this the best design structure 1
Form--Subform 6
Access Daily Entry with multiple entries per field 0
Tough Query 1
Pop-up form that creates record that links 1:1 to main form 0
Go to specific record on form 4

Top