Re: After creating a Form, how do you you put four tables that have a.

Something that you have added is causing 1 of the Foreign Keys to be written
to a Primary Key. Try re-writing the query adding one table at a time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"FindJune" <FindJune@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B60BA89D-6A75-4FBD-9FCD-EFA32C66AFDC@xxxxxxxxxxxxxxxx
Hi There,

I have been asked to creat a form, which I can easily do. Then to put
four
tables which are joined in a relationship to each other together. When I
do
this I keep getting a message stating "The changes you requested to the
table
were not successful because they would create duplicate values in the
index
primary key or relationship. Change the data in the index or redefine the
indexes to permit duplicate entries and try again." How do you redifine
to
allow for duplicates? Because there are 4 tables I naturally have 4
primary
keys and I also have 3 foreign keys to link everything together. Can you
only
connect 3 tables together onto a form? Therefore giving you one junction
table!
--
JPC


.

Relevant Pages

  • After creating a Form, how do you you put four tables that have a.
    ... I have been asked to creat a form, ... were not successful because they would create duplicate values in the index ... primary key or relationship. ... keys and I also have 3 foreign keys to link everything together. ...
    (microsoft.public.access.forms)
  • Re: Get Primary key from Access db
    ... Brendan, article you posted shows how to get index information, i can do it ... But i need keys information - especially foreign keys. ... VARCHAR) and Table2(id integer PRIMARY KEY, idTable1 integer, data ...
    (microsoft.public.access.modulesdaovba)
  • Re: FOREIGN KEY CONSTRAINTS
    ... veracity of your database application. ... keys vs. surrogate keys are available for your reading pleasure. ... surrogate key and a unique index that doesn't allow NULLs on the natural key, ... The EMPID primary key in the employees table remains ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Multiple Records
    ... Oh no...I didn't set the Primary key and the 2 foreign keys for the ... I do have a hard time with ...
    (microsoft.public.access.gettingstarted)
  • Re: How can you create a field that is concatenated?
    ... keys in relational theory, ... PRIMARY KEY in the SQL language, ... Autonumber in the Jet product. ...
    (microsoft.public.access.tablesdbdesign)
Quantcast