Table relation

[Nandu_7]

I have created three tables customer, order,product. All three have primar key unique ID. I have created relationship.
Between customer table and order table and order table and product table.Have entered the data in customer n product table. When I try to enter data in order table the custid and product ID data is not shown which is already entered in both tables

[Micron]

You shouldn't be entering data into tables directly, unless maybe you have a complete understanding of db normalization and related records. Sometimes even then it is not advisable, and sometimes not possible. You should be doing this via forms. Based on your post, there is no relationship between the two tables you've added data to. If you insist on entering data this way, your relationships should include Cascade deletes and updates, but this is risky.

[ranman256]

You must enter the data via a parent/child form.
is that what you're doing?

[Nandu_7]

You must enter the data via a parent/child form.
is that what you're doing?

No just tried to see whether the relationship is working with tables and the values show in the related table. Just sample tables with 3 records

[orange]

You are missing a table based on the most generic Customer Order Product model

Customer --->Order--->OrderDetail<----Product

Get your tables identified and tested before going to Forms.

[ssanfu]

In reference to relationships:

I have created three tables customer, order,product. All three have primar key unique ID. I have created relationship.
Between customer table and order table and order table and product table.Have entered the data in customer n product table. When I try to enter data in order table the custid and product ID data is not shown which is already entered in both tables

When you created the relationships, did you create a relationship between "custid" and "orderID"? If yes, then the relationship is wrong; it is a 1-to-1, not a 1-to-many (as it should be).

The customer table "custid" field (the one) should link to the order table foreign key (FK) field, "custid_FK" (the many).

[Nandu_7]

Should I test the relationship by entering the data through forms

[orange]

Is every Order for 1 Product ONLY?

[Nandu_7]

Actually I need to create a multiple choice question quiz for the team in Access using tables and forms. Every one appearing the quiz the data should be saved in access. what tables should I create in access

[Nandu_7]

Actually I need to create a multiple choice question quiz for the team in Access using tables and forms. Every one appearing the quiz the data should be saved in access. what tables should I create in access

Can any one help me on this ? I have created the table in access Question table, Usertable & Option table.

[Nandu_7]

Can any one help me on this ? I have created the table in access Question table, Usertable & Option table. I need to create multiple choice question quiz. When the user login he should get the form showing the questions and 4 options. The selection option button value should get save in that userid. There are 20 questions in all.

[orange]

Nandu_7,

Did you change subjects? What happened to Product and Order??

[Nandu_7]

Actually it was just an example I want to work on this I have started in access

[Nandu_7]

I am facing problem with relationship and queries

[Nandu_7]

Hi ranman pls can you reply on my latest post