Form/Subform

[Guest]

Hi

Here is the background: I am creating a "helpdesk" application. I have a tbl called tblTICKETS and a table called tblTICKET_LINES. Two tables because I know tickets will often be revisited and I don't want to repeat all the original ticket "header" information each time I add lines to the ticket

Users will perform all the data entry via form(tblTICKETS)/subform(frm(tblTICKET_LINES). The primary key for form(tblTICKETS) will be ticket_id and the primary key for the subform(tblTICKET_LINES) will be ticket_id + line(1,2,3... etc

My question is how can I get the line value to return to 1 on each ticket. For example see the following data

tblTICKET tblTICKET_LINE

id UserName id lin
1000 Joe User 1000
1001 Sue Caller 1000
1002 Bill Abuser 1001
1003 Jane Hacker 1001
1001
1002

My apologies for being so long-winded

Thanks in advance for your help

Gre

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"FormSubform.mdb" which illustrates how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hi,

Here is the background: I am creating a "helpdesk" application. I have a

tbl called tblTICKETS and a table called tblTICKET_LINES. Two tables
because I know tickets will often be revisited and I don't want to repeat
all the original ticket "header" information each time I add lines to the
ticket.

Users will perform all the data entry via

form(tblTICKETS)/subform(frm(tblTICKET_LINES). The primary key for
form(tblTICKETS) will be ticket_id and the primary key for the
subform(tblTICKET_LINES) will be ticket_id + line(1,2,3... etc)

My question is how can I get the line value to return to 1 on each ticket.

For example see the following data:

 

[Guest]

Roger

Thanks I will check it out

Greg