Re: setting up a one to many link
- From: "Al Campagna" <alcampagna@msnewsgroups>
- Date: Sat, 17 Feb 2007 08:32:06 -0500
rzitowsk,
First, let me suggest that you use names that are more descriptive. Rather than
"Master List" (avoid spaces) something like tblCustomers or tblClients would be much
clearer. Or tblSales or tblServices instead of just "Transactions".
The same would apply to your "ID" fields... CustomerID, or ClientID, and SalesID or
ServicesID would be much clearer... particularly anyone elese reading your code.
In keeping with what you have now, I'll use MasterID and TransID though...
MasterID is autonumber, TransID should be Numeric Long. Master is the ONE table and
Transactions is the MANY.
If you have entered data into both of these tables already, and then want to link them
using a one to many realtionship... there may be Transactions that have no matching Master
record (orphans), and that is preventing you from creating the proper relationship.
Set up a query that compares Transactions against Master. The link should be "Show all
records in Transactions, and only those in Master where they match.
If the query produces TransIDs with no corresponding MasterID, then those records need
to be deleted before establishing an Integrity and Cascade link. In other words, there
are records right now that violate Integrity and Cascade linking, and therefore you can
not establish that link until those violations are removed.
TransID MasterID
1324 1324
1625 << TransID orphan (delete)
16957 16927
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions
"Find a job that you love, and you'll never work a day in your life."
<rzitowsk@xxxxxxxxx> wrote in message
news:1171690068.435124.198230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
How would one set up the one to many link between Master List and
Transactions? If the ID in Master List is a primary key, autonumber
field, and the ID in transactions is not a primary key, number field,
would those two fields link. I have tried such a link but I am not
able to enforce referential integrity or get cascade update related
fields or cascade delete related records?
.
- References:
- setting up a one to many link
- From: rzitowsk
- setting up a one to many link
- Prev by Date: Re: Date on subform to equal that of the Parent
- Next by Date: Re: Delete contents of form field upon entry
- Previous by thread: setting up a one to many link
- Next by thread: Using popup form to add data to main form.
- Index(es):
Relevant Pages
|
