Using two tables in one query

[Guest]

I have two tables.

The first table stores job #'s, owner name, address, etc. The job # field
is autonumber.

The second table stores bid results for each of the job #'s.

I would rather not join the 2 tables as the first one is already fairly
large. I would like to create a query that I could use with a form that will
show job # and job name from the first table and also allow the user to enter
the bid results information.

Is this possible??

 

[John Vinson]

I have two tables.

The first table stores job #'s, owner name, address, etc. The job # field
is autonumber.

The second table stores bid results for each of the job #'s.

I would rather not join the 2 tables as the first one is already fairly
large. I would like to create a query that I could use with a form that will
show job # and job name from the first table and also allow the user to enter
the bid results information.

Is this possible??

Possible, and routine!

Use a Subform for the bids. Base your main Form on the Jobs table, and
base the Subform on the bid results table. Set the Master Link Field
to the autonumber value, and the Child Link Field to the long integer
foreign key field in the Bids table.

It's neither necessary nor desirable to create a query joining the two
tables for this purpose (though you will very likely want such a query
for use in a Report).

John W. Vinson[MVP]