T
Tina
Hi,
I am creating a db that tracks software. I have a 2 tables 1 called
original software and the other upgrades.
I have created a form that displays all pertinent info about the original
software. NOTE: One piece of software can have many upgrades. I have added
a subform that tracks who has the software taken out and the keys associated
with the software.
The next form I have created is the upgrade form that contains important
info about the upgrade. The upgrade_ID is found in the original software
table and that how they are linked.
My question is can I have the same subform in both forms? What I would like
is to have a field in the upgrade form called original software that pulls
data from original software table and when you choose an original software
the subform that appears in the original software form will appear in the
upgrade form that way I can make changes to it.
Thanks..
I am creating a db that tracks software. I have a 2 tables 1 called
original software and the other upgrades.
I have created a form that displays all pertinent info about the original
software. NOTE: One piece of software can have many upgrades. I have added
a subform that tracks who has the software taken out and the keys associated
with the software.
The next form I have created is the upgrade form that contains important
info about the upgrade. The upgrade_ID is found in the original software
table and that how they are linked.
My question is can I have the same subform in both forms? What I would like
is to have a field in the upgrade form called original software that pulls
data from original software table and when you choose an original software
the subform that appears in the original software form will appear in the
upgrade form that way I can make changes to it.
Thanks..