Need Help with Joined Tables

[Guest]

Maybe this is simple and I am totally missing it - maybe it can't be done.
Either way, Please excuse my ignorance.

I have 2 tables - JobInfo and BidInfo joined on field Bid ID

Job Info holds job #(autonumber), job name, Owner Name, Bid ID

Bid Info holds Bid ID, job # (Number, Long Integer), Estimator, Bid Date and
Bid Time

I am trying to use 2 seperate forms to enter info into each of the tables.
I would like to enter the job info first which I havent had a problem with.
Then I would like to open the BidInfo form for a specific job number that the
user would enter. Of course this isnt working as the record doesn't exist in
BidInfo. What step am I missing??

Any help is greatly appreciated.

Thanks

 

[Guest]

The question here is the logical relationship between jobs & bids Is there
one bid per job, many bids per job, or many jobs per bid? The answer to this
question will make the answer to your question very straightforward.

In short, if there is only one job per bid, put it all in one table. You can
have each form show only the pertinent fields so that only the job info gets
put in on one form and the bid info on the other.

If there is a one-to-many relationship either way, have the user enter the
"one" side first, then it will be available when he enters the "many" side.