|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 17th, 2004, 01:11 PM
|
|||
|
|||
Duplicate tables in my realtionship window in Access 2000
When I look at my relationship window I have duplicates of most of my tables.
They arn't there in the data view of my tables. If I delete them in the relationship window they pop back up when the relationship window is redisplayed.? 
|
|
#2
December 17th, 2004, 04:51 PM
|
|||
|
|||
|
Hi Marina Are you using lookup functions in your table definitions? If so, have a look: http://www.mvps.org/access/lookupfields.htm The use of lookup functions in table definitions causes this. You should use lookup functions at the form level. HTH, Immanuel Sibero "MarinaKent" wrote in message ... When I look at my relationship window I have duplicates of most of my tables. They arn't there in the data view of my tables. If I delete them in the relationship window they pop back up when the relationship window is redisplayed.?
|
|
#3
December 17th, 2004, 05:19 PM
|
|||
|
|||
|
Thank you: Will simple lookup functions that get data from keyed "value
lists" cause this, or only queries that get data from actual tables tables? "Immanuel Sibero" wrote: Hi Marina Are you using lookup functions in your table definitions? If so, have a look: http://www.mvps.org/access/lookupfields.htm The use of lookup functions in table definitions causes this. You should use lookup functions at the form level. HTH, Immanuel Sibero "MarinaKent" wrote in message ... When I look at my relationship window I have duplicates of most of my tables. They arn't there in the data view of my tables. If I delete them in the relationship window they pop back up when the relationship window is redisplayed.?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple tables - Multiple forms (Access 2000) | Alastair | Using Forms | 0 | November 12th, 2004 03:30 PM |
| Merge data in tables in Access 2000 | Parry Again | General Discussion | 1 | October 8th, 2004 12:49 PM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
| Need help with Access decision | aualias | General Discussion | 23 | June 21st, 2004 02:04 AM |
| Access 2000 Table Locked | bpoteet | General Discussion | 3 | June 18th, 2004 04:36 AM |
Linear Mode
