S
Sharon
I would like some advice about examples or downloads that would enable me to
create a database that manages references needed to be disclosed for a patent
office. Basically, there are three types of references:
A References: U.S. patent numbers, i.e., 1,234,567.
B References: Foreign References, i.e. WO 062345 (this reference can
contain different letters (depending on the country, and may have a different
amount of characters).
C References: Articles and papers, i.e., author name, title of article,
publication name, date, pages.
Secondly, I have a table listing all of my files, i.e, 0001, 0002, 0003,
etc. (which is another database). Each of these files could have any number
of IDS (information disclosure statements) forms submitted with any number of
references per IDS.
For instance,
File 0001
IDS01
15 A References (A1-A15)
3 B References (B1-B3)
5 C References (C1-C5)
IDS02
50 A References (A16-A65)
20 B References (B4-B23)
0 C References
IDS03
15 C References (C6-C16)
File 0002
IDS01
10 A References (A1-A10)
2 B References (B1-B2)
102 C References (C1-C102)
IDS02
1 A Reference (A11)
1 B Reference (B3)
1 C Reference (C103)
These references are submitted in different orders, for example, A1 is a
U.S. reference, but it is not the same for each IDS, same for B1 and C1, etc.
The reason for the database is that many of the same references are used in
different files, but submitted at different times and in a different order.
I have a main form that displays the current file with an "Add Reference"
button that opens another form (see below) and displays the list of IDSs.
Now, I need to somehow select the IDS01, IDS02, and have the list of
references for that particular IDS display.
I have a table for Reference Type: A, B, C. I have a form that has three
buttons, A Reference, B Reference, C Reference, depending on the button I
push, a different form will pop up for me to add a new reference.
Any help is appreciated. As I am mostly a visual type of person, any
download, training or website to reference is appreciated.
Thanks.
create a database that manages references needed to be disclosed for a patent
office. Basically, there are three types of references:
A References: U.S. patent numbers, i.e., 1,234,567.
B References: Foreign References, i.e. WO 062345 (this reference can
contain different letters (depending on the country, and may have a different
amount of characters).
C References: Articles and papers, i.e., author name, title of article,
publication name, date, pages.
Secondly, I have a table listing all of my files, i.e, 0001, 0002, 0003,
etc. (which is another database). Each of these files could have any number
of IDS (information disclosure statements) forms submitted with any number of
references per IDS.
For instance,
File 0001
IDS01
15 A References (A1-A15)
3 B References (B1-B3)
5 C References (C1-C5)
IDS02
50 A References (A16-A65)
20 B References (B4-B23)
0 C References
IDS03
15 C References (C6-C16)
File 0002
IDS01
10 A References (A1-A10)
2 B References (B1-B2)
102 C References (C1-C102)
IDS02
1 A Reference (A11)
1 B Reference (B3)
1 C Reference (C103)
These references are submitted in different orders, for example, A1 is a
U.S. reference, but it is not the same for each IDS, same for B1 and C1, etc.
The reason for the database is that many of the same references are used in
different files, but submitted at different times and in a different order.
I have a main form that displays the current file with an "Add Reference"
button that opens another form (see below) and displays the list of IDSs.
Now, I need to somehow select the IDS01, IDS02, and have the list of
references for that particular IDS display.
I have a table for Reference Type: A, B, C. I have a form that has three
buttons, A Reference, B Reference, C Reference, depending on the button I
push, a different form will pop up for me to add a new reference.
Any help is appreciated. As I am mostly a visual type of person, any
download, training or website to reference is appreciated.
Thanks.