•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 370,597 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,012 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 6244 | Replies: 15
 |
•
•
Join Date: Oct 2005
Posts: 17
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
Hi,
I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem can be over come, keep in mind its an MS Access database as I know SQL DBs act differently with composite keys.
Please Help,
Jay.
I have a composite in a Microsoft Access Database that is not populating, when I add data to the two tables connected to it you would expect the Composite Key to populate as well wouldn't you? But this is not happening, can anyone expalain why and how this problem can be over come, keep in mind its an MS Access database as I know SQL DBs act differently with composite keys.
Please Help,
Jay.
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
do you mean a composite key or a computed field?
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
Thanks for replaying to my post as need all the help. I'm not sure what computed field is ? but I am sure the that this problem is a composite key.
You see what I have done is originally I had a many-to-many relationship but needed to sort (access doesn't like many-to many realtionships) this out so I put a Composite key between the two tables in the many-to-many relationship and this composite key has the just the primary keys of the two tables in it but the problem is that when I add data to the two related tables the composite key doesn't populate.
Is there anyway to do this? Maybe just do it with a form or anotherway? any ideas?
Anyone?
Jay.
You see what I have done is originally I had a many-to-many relationship but needed to sort (access doesn't like many-to many realtionships) this out so I put a Composite key between the two tables in the many-to-many relationship and this composite key has the just the primary keys of the two tables in it but the problem is that when I add data to the two related tables the composite key doesn't populate.
Is there anyway to do this? Maybe just do it with a form or anotherway? any ideas?
Anyone?
Jay.
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
sorry, but you are going to have to give me some details about how your tables are setup. does it look something like this?
table cars
CarID number
CarName vtext
table parts
PartID number
PartName text
table CarParts
CarID number
PartID number
table cars
CarID number
CarName vtext
table parts
PartID number
PartName text
table CarParts
CarID number
PartID number
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
Yes that is exactly right - with the carparts table acting as the composite with only the primary keys inside, nothing else.
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
So is it possible to make that table (carparts table) populate with data, as entries are added to the two connected tables (parts table & car table)?
If so how is this done or is there an alternative way?
If so how is this done or is there an alternative way?
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
ok, so you put entries in the cars table and entries in the parts table and then entries in the CarParts table to link them. Which table is having the problem?
•
•
Join Date: Oct 2005
Posts: 17
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
The tables do have a link (relationship) between them, the question is, is it possible to make the carparts table populate with the primary keys (carID & PartID) when entries are added to the car table and parts tables?
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
i'm confused. what do you want it to populate with?
are you trying to have it do something like
you add
partid = 567, name = carburetor
and
carid = 256, name = chevy
at the same time and then the carparts table will automatically have
partid = 567, carid = 256 automatically added?
are you trying to have it do something like
you add
partid = 567, name = carburetor
and
carid = 256, name = chevy
at the same time and then the carparts table will automatically have
partid = 567, carid = 256 automatically added?
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
- Previous Thread: Frustrated - Please help
- Next Thread: ACCESS Security
