Field set up

[Terrence Carroll]

Hi,

I was wondering what a good setup for a work ticket/issue number field would
be? I have 3 different Analysts working payment discrepancy issues. Each
Analyst is assigned to an issue and each issue can be rleated to many line
items on an invoice. I need fields for each analyst so that each issue will
be numbered sequentially starting at 1. I would like to allow each Analyst
to have their own set of issue #'s (i.e. two analysts coudl have an issue #
of 23). Please let me know if there is a good way to do this from a table
set-up and field set-up.

Thanks,

Terry Carroll

 

[Gina Whipp]

Terry,

You didn't mention what version of Access so I didn't point you a any
specific template... but have you looked here...

http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZAC

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message Hi,

I was wondering what a good setup for a work ticket/issue number field would
be? I have 3 different Analysts working payment discrepancy issues. Each
Analyst is assigned to an issue and each issue can be rleated to many line
items on an invoice. I need fields for each analyst so that each issue will
be numbered sequentially starting at 1. I would like to allow each Analyst
to have their own set of issue #'s (i.e. two analysts coudl have an issue #
of 23). Please let me know if there is a good way to do this from a table
set-up and field set-up.

Thanks,

Terry Carroll

 

[De Jager]

Hi,

I was wondering what a good setup for a work ticket/issue number field
would
be? I have 3 different Analysts working payment discrepancy issues. Each
Analyst is assigned to an issue and each issue can be rleated to many line
items on an invoice. I need fields for each analyst so that each issue
will
be numbered sequentially starting at 1. I would like to allow each
Analyst
to have their own set of issue #'s (i.e. two analysts coudl have an issue
#
of 23). Please let me know if there is a good way to do this from a table
set-up and field set-up.

Thanks,

Terry Carroll