Datasource Question

[jearodOSU]

Hello guys, I just registered to this forum and I wish I would have found it sooner! Lots of info.

anyways, on to my question.

For my project in an advanced vb class I am programming an inventory tracking form with a standard "inventory" template from access 2003. I added a new table to that template, and here's the problem. I haven't had a DB class at all yet (although I learned enough from system analysis to get by). In the parent (assets) table is a primary key of assetID. The table I want to link is the "Transfers" table. The only relationship I want between Assets table and Transfers table is to create a list of transfers THAT particular asset has made.
So...Uhh..If I haven't completely lost you already, How would one go about setting up this relationship (as in primary key, foreign key etc)?

And one last word. I just want it to be understood (as I have seen programming forums flame over people helping students with homework) that this assignment is for my Advanced VB class and the question is merely how the relationship in the database should be set up.

Thank you guys in advance!

Jearod
Go Pokes!

 

[zekeman]

Not sure if I understand your question but have you looked in to

"JOINS" where you are selecting from two or more tables with one

select?

Good Luck

 

[Arg81]

Zekeman is on the right lines but that is later on when you are creating your app, not at database level.

IF you are saying you need to know how to create the PK-FK relationship, and you are using Access, then once your DB is open click on the relationships button.

When this opens, add all your tables and click OK. Now what you should do is drag assetID from your Assets table to assetID in your Transfers table. It will then create the relationship.

If you need anymore help, look here:
http://databases.about.com/od/tutorials/l/aarelationship1.htm

Hope that helps.