By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Any Idea is welcome

P: n/a
I'm working on this database but I'm at a road block. I have two main
forms and a report to design. the first form is call project and the
second form is call filing. the project form is complete; There are
four require code that has to be used for each filing and there are 52
state that filing need to be done using those four require codes. The
one thing that I'm trying to avoid is that when repetitive progress. I
guess the best and simple way will be to have a drop down list of the
require code in the filing form, so when you select a state, you also
select the require code. But my problem is if you only have to file in
10 state instead of 52 you have to select all 52 state to insert a
require code. At the end I will have a report that shows all 52 states
and their require code. What is the best way to do this process
without having to go through the all process.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
kufre wrote:
I'm working on this database but I'm at a road block. I have two main
forms and a report to design. the first form is call project and the
second form is call filing. the project form is complete; There are
four require code that has to be used for each filing and there are 52
state that filing need to be done using those four require codes. The
one thing that I'm trying to avoid is that when repetitive progress. I
guess the best and simple way will be to have a drop down list of the
require code in the filing form, so when you select a state, you also
select the require code. But my problem is if you only have to file in
10 state instead of 52 you have to select all 52 state to insert a
require code. At the end I will have a report that shows all 52 states
and their require code. What is the best way to do this process
without having to go through the all process.


Could you rephrase your question?
Nov 13 '05 #2

P: n/a
I work in a filing unit, we file document in all 52 state for
approvals. when this document first arrive in my department we have to
record the detail of the document. I setup a project form in access to
record all the detail on the document, and it is working perfectly. Now
the next step in this process is to setup a filing form which is pretty
easy but my dilemma is that each document might not need to be file in
all 52 states, some state might automatically approval the document and
some state you have to wait until other major state approval the
document first before you have to file in that state. I want the
filing form to capture all the information without me having to input
it in.

I hope this makes more sense, please any input you have on this will be
greatly appreciated. thanks

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.