Re: Tabel relationships window

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you have multiple relationships involving the same table, you may need to
"copy" the table to create the additional relationship. Don't worry, this
doesn't actually duplicate the table. It is just for convenience in the
relationship window and in the QBE also. Subsequent copies of a table have
a numeric suffix so you can identify them as copies for relationship
definition purposes only.

"Craig Ugoretz" <CraigUgoretz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B9E1028-6CF9-4F94-B13C-7488DAB21490@xxxxxxxxxxxxxxxx
This is maybe hard to explain, but I have table relationships in mind such
as
one-to-one or one-to-many between tables in my database. I enter the
relationships in the table relationships window, but I notice in certain
instances I can not create relationships between tables uinless I create
copies of tables. After I create the copies, exit the table relationships
window, and come back, tables and/or relationships disappear, or extra
relationships appear. This appears very weird. Futhermore, if I delete
all
the tables in the window and start over with displaying new tables, the
relationsiphs previously entered between the tables come back. That too
is
weird, in my opinion. I would like things to "stay put".


--
Craig ugoretz


.