Hi Richard! I am building database with 2 tables, so far. I have earlier defined explicit relations between the CustomerID-fields in both these. Now when i look there is suddenly a third table in "relations"; a copy of the main table but with the addition of "-1" in the name (tablename_1)and with the same relation marked. There is no extra table showing anywhere else but in "relations" and everything seems to work as it should but I am a bit worried. Could it have anything to do with the fact that i canged the foriegn key in my second table from a plain number into a combo box referring to the primary key in the main table, after already having constructed several questions and forms? Do you have any idea why thsi third table is showing and how can I fix this?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.