C
comish4lif
I have a fair amount of Access experience and (for example) can create
queries to prompt users for values to display subsets of data.
What I am having trouble with is getting Access to do the following:
I want to be able to display a record against certain criteria (I can
do this), then I need to be able to display data from a different
unrelated table and finally, plce the new combined record in a third
table that is related to both.
Specifically, I am mapping data element from a legacy system into a new
database. I have a table of source elements, a table of target
elements, both of which are related to the Maps table.
What I wish to do is display a Source element that has no matching
mapped target. And then drill down thru the target table to map/relate
the target to the source. Specifically, after the source is displayed,
I would want to a table from a list of tables in the target (perhaps
while displaying metadata about the target) and then after selecting
the tbale, Access would display the fields in that table (and their
metadata). Finally, clicking a button would activate a Macro would move
the pertinent data to the Maps table to record that relationship.
Where do I start on this? What type of VBA will I need to generate
subforms, etc.
queries to prompt users for values to display subsets of data.
What I am having trouble with is getting Access to do the following:
I want to be able to display a record against certain criteria (I can
do this), then I need to be able to display data from a different
unrelated table and finally, plce the new combined record in a third
table that is related to both.
Specifically, I am mapping data element from a legacy system into a new
database. I have a table of source elements, a table of target
elements, both of which are related to the Maps table.
What I wish to do is display a Source element that has no matching
mapped target. And then drill down thru the target table to map/relate
the target to the source. Specifically, after the source is displayed,
I would want to a table from a list of tables in the target (perhaps
while displaying metadata about the target) and then after selecting
the tbale, Access would display the fields in that table (and their
metadata). Finally, clicking a button would activate a Macro would move
the pertinent data to the Maps table to record that relationship.
Where do I start on this? What type of VBA will I need to generate
subforms, etc.