Multiple secondary forms tied to primary form?

[New to Access]

Here's my dilemma - I have a table from which I've created 2 forms (
opted for a single table for easy queries & reports). Form 1 i
used to add unique records to the Table and Form 2 is used to ad
additional information related to the unique records. My numberin
system is simple

Form 1: records A, B, C, D, etc
Form 2: records A-1, A-2, B-1, B-2 etc

I have no problem adding the 1st record in Form 2 (A-1, B-1 etc.) bu
when I try to add a second (A-2, B-2, etc) I get an error messag
telling me I can't add a duplicate record (i.e. another recor
related to A, B)

I tried changing the field properties to allow duplicate records, bu
that's not really what I want to do, because I do want A, B, C, D t
remain unique records. Not sure what I'm doing wrong

I'm thinking I need a Subform or second table in lieu of my Form 2
but would prefer some advice before spending the time recreating th
info.....Any ideas would be greatly appreciated

 

[Tom Lake]

Here's my dilemma - I have a table from which I've created 2 forms (I
opted for a single table for easy queries & reports). Form 1 is
used to add unique records to the Table and Form 2 is used to add
additional information related to the unique records. My numbering
system is simple:

Form 1: records A, B, C, D, etc.
Form 2: records A-1, A-2, B-1, B-2 etc.

I have no problem adding the 1st record in Form 2 (A-1, B-1 etc.) but
when I try to add a second (A-2, B-2, etc) I get an error message
telling me I can't add a duplicate record (i.e. another record
related to A, B).

I tried changing the field properties to allow duplicate records, but
that's not really what I want to do, because I do want A, B, C, D to
remain unique records. Not sure what I'm doing wrong.

I'm thinking I need a Subform or second table in lieu of my Form 2,
but would prefer some advice before spending the time recreating the
info.....Any ideas would be greatly appreciated!

To use a Subform, you really should split up the table into a master table
(A, B, C, D)
and detail table (A1, A2, B1, etc.)

It's no harder to report using two tables, you can put them both in a query
and use the
query as if it was one table.

Tom Lake