Form/Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Gregory said:
Hi,

Here is the background: I am creating a "helpdesk" application. I have a
Click to expand...
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
Click to expand...
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.
Click to expand...
For example see the following data:
 
Back
Top