Martin F's user avatar
Martin F's user avatar
Martin F's user avatar
Martin F
  • Member for 10 years, 3 months
  • Last seen more than a week ago
  • Vancouver, Canada
4 votes
5 answers
3k views

How can I allow part of a key to be null and enforce uniqueness of records with nulls?

3 votes
1 answer
17k views

How to get the equivalent of array or string GROUP BY aggregate functions in Access?

2 votes
1 answer
545 views

Should I maintain relationships diagrams in the back-end and the front-end?

2 votes
3 answers
299 views

What is the term for a “wide”, non-normalized view/query?

1 vote
1 answer
1k views

How to manage many-to-many relationships when there is also a hierarchy among the many?

0 votes
1 answer
250 views

Convert an interaction matrix into a ternary relation

0 votes
1 answer
403 views

How to save the design of an Access database -- not the content -- as text?

0 votes
1 answer
1k views

How to subtract records from a table based on their existence in another

0 votes
1 answer
2k views

How to prevent #Error values derived from Nulls in an outer join