two fields to make up a forgin key

  • Thread starter Thread starter Gary Hull
  • Start date Start date
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
 
Gary

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Man to Many Relationship 1
numbering multiple key fields 4
Nested form filtering 3
One table too many! 10
Normalized Tables 1
Duplicate record in Form and Subform 0
Adding records - automatic numbering with two primary keys 2
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Back
Top