Master & Subforms Add New Records Dilemma

[McArthurGDM]

Hi,



This is a follow-up from a previous post that you can delete because I've managed to simplify my question a little better.

I have two Tables, Table A and Table B

Table A and B have a one to many relationship with A (one) and B (many).

I have a Master form that displays information for Table A. Also, I have a subform within this Master that displays information for Table B.

As I scroll through the records of A, you can see the 1-many relationship elucidated in the subform with many being displayed for Table B.

I run into a dilemma, though, when I try to ADD a new record to Table A (and in turn Table B).

---

When I add a new record, there is no Primary Key left to be displayed since this primary key is generated from a query.

Hence, when I move to a new record, I can not save the record because there is no primary key. Since there is no primary key, there is nothing that i can input into the subform either.

I want to create the primary key from values entered in the field. However, i CAN NOT create a relationship with an expression for field values.

I can not get around this issue and it's irritating me to no end.

[June7]

What do you mean the primary key is generated form a query? How would that be?

If you want to provide db for analysis, follow instructions at bottom of my post.