G
Guest
My apologies if this topic has been discussed, but I searched and could not
find an answer to my specific inqury.
I have two tables (tblSeries and tblDocTypes). The only thing they have in
common is a field "Series Code".
I also have a form on which I have two combo boxes. One for Record Series
and one for Document Type. These boxes are linked to the corresponding field
in their table ("Record Series" = "Series Name" from tblSeries and "Document
Type" = "Series Name" from tblDocTypes).
What I would like is when a selection is made from the combo box "Document
Type" it will list only that "Record Series" it belongs with. Here is some
data from the two tables:
tblDocTypes tblSeries
Series Code Series Name Series Code Series Name
ACC Assets ACC Accounting
ACC Banking DEV Development
ACC Capital COR Corporate
COR Stocks INS Insurance
COR Partnership HR Human Resources
DEV Associations
DEV Building
So, if "Assets" was chosen as a "Document Type" then "Accounting" would be
returned in the "Record Series" box.
Hope this makes sense. Thanks in advance for the help!
Ember
find an answer to my specific inqury.
I have two tables (tblSeries and tblDocTypes). The only thing they have in
common is a field "Series Code".
I also have a form on which I have two combo boxes. One for Record Series
and one for Document Type. These boxes are linked to the corresponding field
in their table ("Record Series" = "Series Name" from tblSeries and "Document
Type" = "Series Name" from tblDocTypes).
What I would like is when a selection is made from the combo box "Document
Type" it will list only that "Record Series" it belongs with. Here is some
data from the two tables:
tblDocTypes tblSeries
Series Code Series Name Series Code Series Name
ACC Assets ACC Accounting
ACC Banking DEV Development
ACC Capital COR Corporate
COR Stocks INS Insurance
COR Partnership HR Human Resources
DEV Associations
DEV Building
So, if "Assets" was chosen as a "Document Type" then "Accounting" would be
returned in the "Record Series" box.
Hope this makes sense. Thanks in advance for the help!
Ember