-
1 to 1 but want 1 to many
So I am trying to get my database finished here. I think I want a one to many but can only get a one to one.
If someone could please take a look at what I have going on here I would appreciate it. Its still kind of a mess so it will need trimming once I get it working.
If you take the time to look at it please open the Overview form. That's basically what I'm trying to get working. I want multiple entries for the events to be available. Each one of these events will be a contract and the maintenance schedule covered by that contract with approximate service dates.
If I try to connect the assetid to the eventid I can only get a one to one. It seems to me I need a one to many so that I can have multiple events under one asset.
Any help would be awesome.
-
I don't see anything that relates Overview to any of the other tables. Linking AssetID to EventID isn't going to work because you need a FOREIGN KEY in tblEvent for AssetID instead. If you link a PK field to a PK field, you will get a ONE TO ONE relationship only.
-
Sorry yeah I removed the relationship I had because it wasn't working. I didn't realize that about the PK. I'll throw a foreign in there. Thanks for the help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules