Data not showing properly in subform

[Michelle]

I have a form for software tracking it has a sub form for license information
and one for system the software is assigned to.
When I enter information for license information for one piece of software
it shows up in all of them (same with system but if I get the one to work
then I will be able to get the other to work)

tblsoftware
ID (AutoNum)
Company
Title
MediaType
NumMedia
NumLicense
NumberAssigned

tblLicenseKey
ID (AutoNum) - Primary Key
SWID
LicenseKey
CertiicateNum
OrderNum
ExpDate
NoPerCert

Relationship is one to many tblSoftware [ID] to tblLicenseKeys [SWID]

For some reason when I enter data into the subform it is not getting the ID
from the mainform (can this be done?)

 

[Al Campagna]

Michelle,
Have you entered the Parent and Child property of the subform as...
Parent = ID
Child = SWID
(SWID should be a Numeric Long field)

Even though you may have set up a relationship in the Relationship
window, you still have to call that relationship on your forms with
the Parent/Child.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Michelle]

That worked...thanks

Michelle,
Have you entered the Parent and Child property of the subform as...
Parent = ID
Child = SWID
(SWID should be a Numeric Long field)

Even though you may have set up a relationship in the Relationship
window, you still have to call that relationship on your forms with
the Parent/Child.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a form for software tracking it has a sub form for license
information
and one for system the software is assigned to.
When I enter information for license information for one piece of software
it shows up in all of them (same with system but if I get the one to work
then I will be able to get the other to work)

tblsoftware
ID (AutoNum)
Company
Title
MediaType
NumMedia
NumLicense
NumberAssigned

tblLicenseKey
ID (AutoNum) - Primary Key
SWID
LicenseKey
CertiicateNum
OrderNum
ExpDate
NoPerCert

Relationship is one to many tblSoftware [ID] to tblLicenseKeys [SWID]

For some reason when I enter data into the subform it is not getting the
ID
from the mainform (can this be done?)