Multiple secondary forms tied to primary form?

  • Thread starter Thread starter New to Access
  • Start date Start date
N

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
 
New to Access said:
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!
Click to expand...


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
 
Back
Top