building a one to many relationship

[medused]

I/m new to Acess 2010. I've built two tables, "customer data" and "customer orders". The primary key is "Customer ID", which is not an autonumber, it's text.


When I go to the relationship builder and try and joing those tables by using the "customer ID" as the common denominator to join the tables, and I click "enforce relational integrety" it gives me no option to choose other than a "one to one" relationship, when I want a "one to many" relationship, obviously. Any help would be appreciated.

[pbaldy]

CustomerID isn't the primary key in the orders table, is it?

By the way, I wouldn't have the spaces in your object names. You'll regret it in the long run.

[medused]

CustomerID isn't the primary key in the orders table, is it?

By the way, I wouldn't have the spaces in your object names. You'll regret it in the long run.

----
Yes, customer ID is the primary key in orders..... how else could it be done, to joing customers with orders? I don't understand your comment about spaces in my objects names.... what does that mean. Thank you for your help. Bob

[pbaldy]

Customer ID can't be the key in orders, or you won't be able to have more than one order for a customer. Normally you'd have an order ID field as the primary key. Customer ID would be referred to as a foreign key in the orders table.

As to spaces, I mean the space in "Customer ID" for example. I would make it "CustomerID". You'll find when you get into coding and such that the spaces are more trouble than they're worth. You can get away with them but you are forced to bracket them: [Customer ID].