merging 2 tables

[keilola]

Hello everyone I am new to the website. I am trying to create a database to
make my company run smoother and more efficient in the quality department.
Here is what I have:

I have 2 tables, main table and car table. They each have a primary key that
auto indexes for each new record.

In the main table, after I fill out all of the information, there is a
checkbox that the user would click if they need to take particular
information from that particular record, and generate a report. I made a
query called CARQRY that sorts the main table for all of the records that
have the check box marked 'yes'. So now I can view just those records.

In the CAR table, there is a primary index called CAR #which is AutoNumber.
This is going to be the number that is going to give a serialized number to
all the records that require a CAR (Corrective Action Request) . I can enter
information into this table and all the records will have unique serial
numbers from the primary key.

Is it possible to take the records from CARQRY and somehow obtain the next
number from the CAR table so that everything requiring a CAR is serialized in
order?

I am sure that there is a better way to do this than the route I am going.
If there are suggestions to make it more simple, please feel free. If
possible, I can upload the 2 tables and the query that I am speaking of.

if there is any confusion, please feel free to email me and I will answer
the best that I can. Thanks in advance for your time and assistance.

People have told me about update query, append query....i just dont know how
those work.

 

[keilola]

even if it was possible to take the records from the carqry (created from
main table) and merge them with the CAR table which would index the CAR #
field, that would be awesome! The CAR can have data not related to the main
table or carqry but in some cases, the data in carqry would need to be added
to CAR table.]

sorry if confusing!