two fields to make up a forgin key

G

Gary Hull

I have a many to many table with 2 fields that makes up the primary Key

pkJobName
pkCabType


If I want to use this table as a parent table in a form does the sub table
have to have two foagain keys?

fkJobname
fkCabType
 
J

Jeff Boyce

Gary

Do you have some other mechanism in mind for telling Access that the two are
related?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Gary Hull

Gary

Do you have some other mechanism in mind for telling Access that the
two are related?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

Jeff

No what I need to be able to do Is select a Job name and then slect the
type of Cabinets that would apply to the job name, from there have a sub
form to enter information about the cabinet that was selected the would
be a many subform
 
J

Jeff Boyce

Gary

You are describing forms and subforms. I don't have a clear picture of the
actual table structure, which is where it all starts.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top