Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. I need to create a relationship between Table 1 and Table 2 which shows who owns the ship.
Unfortunately my ships microsoft access 2013 foreign key free download Table 2 can have multiple owners up to 5 at the same time. My problem arises when I try to create a series of linking fields in Table 2.
Can anyone recommend any workarounds so I can show multiple owners taken from the Owners table in the Ships table? In the case you explain, you have a many-to-many relationship between Microsoft access 2013 foreign key free download and Owners, which MUST translate into a "relationship table" in the relational model. The problem is that it looks like Access doesn't allow Nullable FK's and so all Owner fields would have to be filled in, no matter how many owners there are.
You can then microsoft access 2013 foreign key free download as many Owners as you like. However I still thing the suggestion here is a good one. Repeating Groups Owner 1 to 5 is against Normalisation rules, and this suggestion is normalised.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 7 years, 11 months ago. Active 7 years, 11 months ago. Viewed 6k times. Thanks for your help! Improve this question. What is not working? After trying a bit, it can easily work, but you just have to ensure microsoft access 2013 foreign key free download do not edit the existing relationship Access asked me if I wanted that.
Confusing and imho unnecessary, but it works : — oerkelens. Add a comment. Active Oldest Votes. Your database design is definitely incorrect. Improve this answer. Patrick Honorez Patrick Honorez If there can ever be more than those 5 owners, your are right. And I maintain my point of view. The limitation to 5 owners is a constraint that does not constitue an exemption for a proper 3rd or 4th NF — Patrick Honorez.
Since when does Access not allow nullable fields, be they foreign key's or not? I'd like to see a source of that : — oerkelens. It does, but these are I think Long Number and it wouldn't let me set them null when I tried Access Just tried in and it works : You made me wonder myself : — oerkelens.
I am having a little diff here. I have one table. Primary key of this table is set as Foreign key to two different table. But when I am doing so I did not get any results from table. I us MS Access What I need to do to map this relationship? Any Steps? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Migrating metrics from InfluxDB to M3. Podcast Is crypto the key to a democratizing the metaverse? Featured on Meta. Reducing the weight of our footer. Upcoming responsive Activity page.
Community input needed: The rules for collectives articles. Related 0. Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.
Accept all cookies Customize settings.
