Relationship problem?

Help needed please. This sounds very basic but I'm a newbie
to Access VB. I'm using Access XP. I have three tables with
fields below as example:

1. tblOwner
ownerID PK(Autonumber)
name
Address
TelNo
2. tblLicense
LicenseID PK(Autonumber)
OwnerID FK
LicenseNbr
DateIssued
DateExpired
3. tblMachines
machineID PK(Autonumber)
LicenseID FK
SerialNbr

Table Owner can have many licenses (1 to many). Table License can have many
machines (1 to many). What I'm trying to do is whenever a new
license number (LicenseNbr) is added, I need to have the table machine
create a new set of records based on the new license number. Any help
will be very much appreciated. Thanks in advance.Table Owner can have many
licenses (1 to many). Table License can have many machines (1 to many).
What I'm trying to do is whenever a new license number (LicenseNbr) is
added, I need to have the table machine create a new set of records based
on the new license number. I've created a main form for the tblOwner with
two subforms but I'm having trouble with related records on the tblLicense.
Any help will be very much appreciated. Thanks in advance.

Canice

Canice

I understand the concept of one person (owner) holding multiple licenses.
I'm a little fuzzy on how one license could be applied to more than one
machine (?are we talking about vehicles, chainsaws or computers?) -- in my
world licenses either belong to a person or belong to a machine
(one-to-one)..

So, why do you want the creation of a license to be automatically applied to
multiple machines? And which ones? If you have 100 machines, do you want
the license applied to every one?

If EVERY machine gets a new license, you don't need to record the fact, do
you? You just need to know the licenses...

What am I missing?

--
Good luck

Jeff Boyce
Access MVP

"Canice Diaz" wrote in message
...
Help needed please. This sounds very basic but I'm a newbie
to Access VB. I'm using Access XP. I have three tables with
fields below as example:

1. tblOwner
ownerID PK(Autonumber)
name
Address
TelNo
2. tblLicense
LicenseID PK(Autonumber)
OwnerID FK
LicenseNbr
DateIssued
DateExpired
3. tblMachines
machineID PK(Autonumber)
LicenseID FK
SerialNbr

Table Owner can have many licenses (1 to many). Table License can have
many
machines (1 to many). What I'm trying to do is whenever a new
license number (LicenseNbr) is added, I need to have the table machine
create a new set of records based on the new license number. Any help
will be very much appreciated. Thanks in advance.Table Owner can have
many
licenses (1 to many). Table License can have many machines (1 to many).
What I'm trying to do is whenever a new license number (LicenseNbr) is
added, I need to have the table machine create a new set of records based
on the new license number. I've created a main form for the tblOwner with
two subforms but I'm having trouble with related records on the
tblLicense.
Any help will be very much appreciated. Thanks in advance.

Canice

to model your relationships, you need to nest your subforms. mainform is
tblOwner, correct? and subform is tblLicense, correct? that will model the
one-to-many relationship between owner and licenses. now, add a subform to
the tblLicense subform. that nested subform is for tblMachines. that will
model the one-to-many relationship between license and machines.

hth


"Canice Diaz" wrote in message
...
Help needed please. This sounds very basic but I'm a newbie
to Access VB. I'm using Access XP. I have three tables with
fields below as example:

1. tblOwner
ownerID PK(Autonumber)
name
Address
TelNo
2. tblLicense
LicenseID PK(Autonumber)
OwnerID FK
LicenseNbr
DateIssued
DateExpired
3. tblMachines
machineID PK(Autonumber)
LicenseID FK
SerialNbr

Table Owner can have many licenses (1 to many). Table License can have
many
machines (1 to many). What I'm trying to do is whenever a new
license number (LicenseNbr) is added, I need to have the table machine
create a new set of records based on the new license number. Any help
will be very much appreciated. Thanks in advance.Table Owner can have
many
licenses (1 to many). Table License can have many machines (1 to many).
What I'm trying to do is whenever a new license number (LicenseNbr) is
added, I need to have the table machine create a new set of records based
on the new license number. I've created a main form for the tblOwner with
two subforms but I'm having trouble with related records on the
tblLicense.
Any help will be very much appreciated. Thanks in advance.

Canice

Hi Jeff,

Thanks for replying. The reason for this is that where I work, we control
the machines individually. I'm talking about amusement machines such as
poker machines. We tag each one of them a unique number and we keep track
of their mfg serial numbers. The owner is required to obtain another
license if he wants to add more machines to his establishment (place of
business). That is why one owner can have many licenses. Thanks Jeff.

"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Canice

I understand the concept of one person (owner) holding multiple licenses.
I'm a little fuzzy on how one license could be applied to more than one
machine (?are we talking about vehicles, chainsaws or computers?) -- in my
world licenses either belong to a person or belong to a machine
(one-to-one)..

So, why do you want the creation of a license to be automatically applied
to
multiple machines? And which ones? If you have 100 machines, do you want
the license applied to every one?

If EVERY machine gets a new license, you don't need to record the fact, do
you? You just need to know the licenses...

What am I missing?

--
Good luck

Jeff Boyce
Access MVP

"Canice Diaz" wrote in message
...
Help needed please. This sounds very basic but I'm a newbie
to Access VB. I'm using Access XP. I have three tables with
fields below as example:

1. tblOwner
ownerID PK(Autonumber)
name
Address
TelNo
2. tblLicense
LicenseID PK(Autonumber)
OwnerID FK
LicenseNbr
DateIssued
DateExpired
3. tblMachines
machineID PK(Autonumber)
LicenseID FK
SerialNbr

Table Owner can have many licenses (1 to many). Table License can have
many
machines (1 to many). What I'm trying to do is whenever a new
license number (LicenseNbr) is added, I need to have the table machine
create a new set of records based on the new license number. Any help
will be very much appreciated. Thanks in advance.Table Owner can have
many
licenses (1 to many). Table License can have many machines (1 to many).
What I'm trying to do is whenever a new license number (LicenseNbr) is
added, I need to have the table machine create a new set of records based
on the new license number. I've created a main form for the tblOwner
with
two subforms but I'm having trouble with related records on the
tblLicense.
Any help will be very much appreciated. Thanks in advance.

Canice