1 Comment June 24th, 2008

Using Access Database 2003 having trouble creating relationships between tables?

troubled relationships
Kiba asked:


I’m practicing using Access Database application but I’m having trouble forming relationships between the tables.

I have 3 tables:

Customer – CustomerID (PK), Name, Address…

Order – OrderID, OrderDate, CustomerID (FK), ProductID (FK)

Product – ProductID (PK), Description, Price…

Then I linked them together and enforced referential integrity. Then I successfully inported the data file. My problem is that the ProductID and CustomerID fields in the order table are empty. I can’t seem to get these fields to reference back to their original tables.

Sorry if this is confusing any suggestions will be helpful. Thanks in advance!

Kerry

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
This entry was posted on Tuesday, June 24th, 2008 at 2:45 am and is filed under Troubled Relationships. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Using Access Database 2003 having trouble creating relationships between tables?”

  1. Sambo Says:
    June 24th, 2008 at 4:49 pm

    Ik las in een van mijn MS Access tekst boeken die hij gemakkelijker te maken de tabellen aanvankelijk zonder waarmee referentiële integriteit. Maak de tabellen, dan is het importeren van gegevens in elke tafel. Voordat u weer inschakelen referntial integriteit u ervoor te zorgen dat de gegevens heeft 'integriteit'. Gebruik de wizard vinden duplicaten zoekopdracht naar 'clean-up' uw gegevens nadat deze is bij de toegang. Zodra dit is alles opgeruimd, moet u dan in staat zijn met de handhaving van de integriteit-regels.

Leave a Reply