Thanks Bill, I am going to have something similiar to that with my interior designers and contractors.
If you have the time, how do you get a second table on a form? Thank, Boyd ---- Bill Downall <[EMAIL PROTECTED]> wrote: > And... > > You can also have a column that has both a primary and and a foreign key > defined for it. For example, a membership association might have a table of > Members with a primary key defined on MemberID. Some members are also on the > Board of Directors. There could be a separate Directors table that also has > a MemberID column, which is a primary key in the Directors table, and also a > Foreign Key referencing Members.MemberID. > > MemberID is unique within Directors, but also has to be a valid member from > the Members table. > > Bill > > On Wed, Apr 30, 2008 at 6:17 PM, Rachael Malberg < > [EMAIL PROTECTED]> wrote: > > > Oh sure and did you know you can have Primary and mulitple Foreign Keys > > with in the same table? > >
