I have two tables and i want establish a relationship with Enforce Referential Integrity but i can't . it out me the next error " Microsoft Access can't create this relationship and enforce refere...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10029911.html
Zones:
MS AccessDate Answered: 11/20/1997 Grade: A Views: 0
No matter how many times I put together databases (beleive me, I've do a few) I always have problems resolving many-to-many relationships. We all have our hangups I guess.
Any way, I'm putting to...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10035931.html
Zones:
MS AccessDate Answered: 01/21/1998 Grade: A Views: 0
I used to use VB4. When using Visdata, I could easily create one to one and one to many relationships. However, now that I am using VB5, I have found that I no longer know how to create these relat...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10160864.html
Zones:
VB DBDate Answered: 05/19/1999 Grade: A Views: 0
Hi. Working on a basic Inventory db. I've got a main Asset table that holds all common info (manufacturer name, model # etc) on assets (computers, routers, etc) and I've decided for more detailed i...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_12054099.html
Zones:
MS AccessDate Answered: 12/15/2000 Grade: A Views: 0
Hi, I am having a slight problem with a relationship which I was wondering if
anybody could help out with.
I have 2 files - I file holds employee details (Employees.fp5) the other is
a file ...
http://www.experts-exchange.com/Apple/Software/Filemaker_Pro/Q_20402091.html
I need to establish a relationship between 5 tables that already exist. I need a one to many relationship.
Were can I find information on how to do this. Do I create a query or do I use rela...
http://www.experts-exchange.com/Other/Miscellaneous/Q_20413077.html
Zones:
MiscDate Answered: 01/12/2003 Grade: A Views: 0
Lo all!
I am a newbie using Access but have to build a database with several many-to-many relationships chained. This is because the project consists of some kind of tree-shape structure. The DB m...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20442496.html
Zones:
MS AccessDate Answered: 01/07/2003 Grade: B Views: 0
I am having difficulties in producing the required N:M (many-to-many) unary (recursive) relationships using the 'Relationships' tool in Microsoft Access 2000.
Can anyone help as I am pulling my ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20673272.html
Zones:
MS AccessDate Answered: 12/10/2003 Grade: A Views: 0
I have this business logic to model. It has users and addresses. Right now the system only needs two addresses per user, so I created two columns in
the user table to store the FK to a row in the ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20707235.html
Zones:
DatabasesDate Answered: 08/13/2003 Grade: A Views: 0
I've made a database with several tables and the relationships all seem to be OK. However, when I make a form that displays info from more than two of the tables nothing shows up onscreen when I t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20745777.html
Zones:
MS AccessDate Answered: 09/29/2003 Grade: A Views: 0
