Sub Records & Autonumbers

[samg2012]

Hey,



After hoping google would be my friend, I've turned to you guys for help!

I have a table that has an autonumber, but I need 'sub autonumbers'? within these records. Hope that makes sense. Like this:

Record (Auto Number) 1
Sub Record 1.1
Sub Record 1.2
Record (Auto Number) 2
Sub Record 2.1
Sub Record 2.2
Sub Record 2.3

In the example above I have tried to illustrate how I need the system to work, record 1 has two sub records under it and record 2 has 3.

Am I going about this in the wrong way?
Thanks

[orange]

In plain English WHAT is a record and a subRecord? If the "autonumber" is for your use, you probably shouldn't be using an autonumber for that field.
It's hard for a reader to know which is the right or wrong way to do anything. That is, until we understand what the "anything" really means, and preferably in simple plain English business terms.

[samg2012]

Apologies, I doubt I explained what Im trying to do very well. Let me try again:

So I have a list of issues:

Issue 1
Issue 2
Issue 3

Inside these records (issues) I want to have updates, like this:
Ref 1 Issue 1 Update 1
Ref 2 Issue 1 Update 2
Ref 3 Issue 1 Update 3
Ref 4 Issue 2 Update 1
Ref 5 Issue 2 Update 2

Currently 'Ref' is numbered using an autonumber, and 'Issue' is linked to another table with issues as PK. I cannot find a way to get the 'update' to sequentially number.

Thanks again

[orange]

A general model of you situation would be 2 tables

tblIssue------->tblIssueComment

where tblIssue has fields

IssueId PK
IssueName
IssueNotedDate
IssueDescription

and tblIssueComment has fields

IssueCommentID PK
IssueComment
IssueCommentDate
IssueCommentMadeBy
IssueId Fk to tblIssue

These would fit into a Form/Subform with tblIssue in the MainForm and tblIssueComment in the subform.
The tables would be linked on IssueID
You have to have an Issue, before you can add a comment.

I'm not clear on why you need the numbers you seem to want.
All comments can be associated with the right issue by means of IssueID.
All comments can be sorted based on IssueCommentDate

I have included an IssueCommentMadeBy to record the person's name if needed, but it may not be necessary.

You could have an IssueNo which you control. Let's say you start with 1. It would be a different field than IssueID in my view. IssueId and IssueCommentId could/would be autonumbers.
For the next sequential number, you would get the maximum currently assigned IssueNo and add 1 to it.

You could have, but don't need in my view, an IssueCommentNo as well; and set up like IssueNo.

There is a free video on form/subform at https://www.youtube.com/watch?v=YZKN_-P6wck

Good luck