[Durghan]

Cal, thanks for the response. Unfortunately, at this time, after having read your words, I am probably a bit more confused than I think I am. I won't have a chance to work on anything till next week probably so I'll have to come back here and see what I can understand at that time. If I have more questions i will post them.

Which DM Tool are you refering to that lets you draw the lines for the relationships? Thanks.

[Durghan]

I have to admit, I am very new to Databases…I have a very basic concept of what they can do which amount to pretty much just the fact that they can store and manage information. It's how to make them do it most efficiently that I am lost on.

I just checked my tables and I set them up to all have primary keys solely to make sure they have primary keys…They are all set as int but with differing numeric values. One table has it set at 7 while another has it set to 3, does that matter?

When I look at the table tree on the left side of the screen (I've only just now started trying out this software so excuse improper terminology) My tables all have a columns folder and an indexes folder. All the indexes folder contain an item that is the same name as my primary keys.

Basically I have three tables whose information needs to be provided to a fourth (if I understand this correctly). How do I create my fields in the fourth table that draw their information from the other three? Or am I straying down some dark and ugly path?

Thanks…

-=-=-=-=-=-==-=-=-=

Since posting the above I decided try just linking my 3 tables to the fourth using just the primary key fields and it's worked fine…But I'm confused, I thought I had to link the primary key of a certain table (table B for example) to the field in Table A where it's information would be used. This assumption is based on watching a co-worker create relationships on tables in MS Access where it seemed the line connecting the two tables went from the Primary key in one table to the corresponding field in another.

Can anyone clarify this for me? Thanks.

[Author]

Posts