S
Sharon
I have a database that lists records for patent
applications. My problem is that one application
may "depend" from a previous patent. For instance, using
Patent Applications A, B, C:
Patent Application A is the "parent" patent and it was
filed on 1/1/05 (in other words this is the first patent
filed on this date for this invention).
Patent Application B depends from Patent Application A in
that it is a continuation of Patent Application A.
Patent Application B was filed on 2/5/5, but because the
parent Patent Application A was filed on 1/1/05, that is
the date the Patent Office uses as the priority date.
Patent Application C was filed on 3/10/5 and is a
continuation in part of both patent applications A and B
and, therefore, the priority date is again 1/1/05.
As can be imagined, in the world of patents, the priority
date of a patent can sometimes be extremely crucial to an
invention. In each instance, A, B, C, is considered
a "family" but the filing information regarding the
patents is different for each of them. However, it is
extremely important to "link" these patents to each other
so you can see the past history. The list can go on and
on, I just use A, B, C for simplicity.
I created a tab called "Family". In it I have fields
called ParentType1, ParentType2, ParentType3, etc., which
designates whether it is a continuation, divisional . . .
and then there are fields for Parent1SN, Parent2SN,
Parent3SN.
What I am trying to do is create a subform that when I
enter into the field, for instance, Parent1SN, a subform
will open showing the information for the PARENT of the
application. For instance, when I am in the
field "Parent3SN," I want a subform to show of a query of
the information that I want to see. I tried using the
Lookup Wizard, but, of course, I get the message "No
valid fields can be found in qry. You may have selected
a query that uses the table you're adding the lookup
column to."
Any suggestions?
applications. My problem is that one application
may "depend" from a previous patent. For instance, using
Patent Applications A, B, C:
Patent Application A is the "parent" patent and it was
filed on 1/1/05 (in other words this is the first patent
filed on this date for this invention).
Patent Application B depends from Patent Application A in
that it is a continuation of Patent Application A.
Patent Application B was filed on 2/5/5, but because the
parent Patent Application A was filed on 1/1/05, that is
the date the Patent Office uses as the priority date.
Patent Application C was filed on 3/10/5 and is a
continuation in part of both patent applications A and B
and, therefore, the priority date is again 1/1/05.
As can be imagined, in the world of patents, the priority
date of a patent can sometimes be extremely crucial to an
invention. In each instance, A, B, C, is considered
a "family" but the filing information regarding the
patents is different for each of them. However, it is
extremely important to "link" these patents to each other
so you can see the past history. The list can go on and
on, I just use A, B, C for simplicity.
I created a tab called "Family". In it I have fields
called ParentType1, ParentType2, ParentType3, etc., which
designates whether it is a continuation, divisional . . .
and then there are fields for Parent1SN, Parent2SN,
Parent3SN.
What I am trying to do is create a subform that when I
enter into the field, for instance, Parent1SN, a subform
will open showing the information for the PARENT of the
application. For instance, when I am in the
field "Parent3SN," I want a subform to show of a query of
the information that I want to see. I tried using the
Lookup Wizard, but, of course, I get the message "No
valid fields can be found in qry. You may have selected
a query that uses the table you're adding the lookup
column to."
Any suggestions?