Access database relationships

I think you mean Many-To-Many relationship
Check my attachment
Adjustments.accdb

I see that you created a Form. I need in the table name Two_tbl all records from Field  St and next each St the field Acode from the One_tbl.

Just use the comboboxes to populate Two_table

Attached is a revised version of the database. To get what I need, I created a relationship (see relationships in database tools. I then opened One_tbl, expended the first plus sign and copied the 50 St codes. I then opened the next plus sign and copied the 50 St codes. This is how I got my table two to show all the codes that I need see below sample and from attached see table two. Is there a way to do what I did without copying the fifty states into each primary key in table One?

St      Acode      Amount      Percent
AK      15(a)            0.00
AK      15(c )            0.00
AL      15(c )            0.00
AL      15(a)            0.00
Test_Adjustments.accdb

Easy...run this Query

INSERT INTO Two_tbl ( ACode, St )
SELECT One_tbl.ACode, States_tbl.St
FROM One_tbl, States_tbl;

Select allOpen in new window

I entered what you sent in  SQL in a query. When I run the query the records don't get updated. I think I am doing something wrong.

Make table code works. Thank you.

Conernesto

Ideally I would like that every new primary key that is added on table One is also added on table two?

Just try it...