Table autonumbers in a Query

[Debbie Toney]

I have 2 tables, both have 1 field each with an autonumber: one is Contact ID field and the other is Payment ID field.

When I use both tables in a query and I try to add a record directly in the query (I know strange but stay with me), the Contact ID autonumber works and generates a new number for the record, however the Payment ID field does not autogenerate a new number for the same record.

What can I do to make both autonumber fields generate a new number for one new record entered into the query?

Thanks in advance.

[Rabbit]

You have to put one in a subform, most likely the payments, and then link the two together.

[Debbie Toney]

@Rabbit
I'm working in a query using 2 tables. Both tables have their own autonumber field. One field does work properly and autogenerate a number when I add a record from within the Query, however, the 2nd autonumber field from the other table doesn't not autogenerate a number, it leaves it blank.

My question is, from within the Query - how do I get the 2nd autonumber field to generate an autonumber like the first autonumber field did?

Thank you.

[Rabbit]

When using a query that references more than one table, you can only insert into, at most, one table. There's no way around that. What you have to do is break it up into a main form / subform setup.