I'm attempting to create a complicated view of some M-M relationships. This
will be a user form for a security system. The form will contain a
pageframe..page 1 is the user information, Page 2 the groups the user
belongs to (selected via a mover), and Page 3 the additional rights the
user has (set via a grid). My files are layed out like this (I've only
included pertinent fields):
Users
-------------
pkUsers (primary Key)
UserId
Groups
------------
pkGroups (primary Key)
UserGrp
-------------
pkUserGrp (primary key)
rkUsers (relates to Users.pkUsers)
rkGroups (relates to Groups.pkGroups)
Items (All possible items that you can assign rights)
---------------
pkItems (primary Key)
UserItem
--------------
pkUserItem (primary Key)
rkUsers (relates to User.pkUsers)
rkItems (relates to Items.pkItems)
So, UserGrp is used to link Users.dbf to Groups.Dbf and UserItem is used to
link User.dbf to Items.dbf
This should be setup so that the user will enter a UserId to update and
then a parameterized view will be populated. My question is, how do I
create the view? I keep getting errors from the view designer that certain
key linking fields can't be found. The exact field varies, depending on the
order that I add tables to the view designer.
--
Craig Berntson
Salt Lake City Fox User Group