Relationship problem?

[Canice Diaz]

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

 

[John Vinson]

Help needed please.

Answered in m.p.a.forms.

Please, don't multipost. The web interface doesn't make it easy, but
you can "crosspost" - click the Advanced Options below the message box
and choose Crosspost. Name the groups to which you want the message
posted (one or two more at the most). Replies to a crossposted message
show up in all the groups, and it's easier for the volunteers to
identify already-answered messages.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps