Question Table Relationship Issue

Helpee

Registered User.
Local time
Today, 22:04
Joined
Feb 23, 2014
Messages
11
trans.gif



I have a new database. I've imported data from an Excel 2013 spreadsheet to a Table (Contact) & obviously not being, it would appear, at all proficient I seem to have caused an issue with 'pulling up' data stored in the tables via various forms. This issue is not limited to the Table I appended the data to and seems to impact on the Relationships on a number of tables. It would appear that when I attempt to pull up data from a Table(s) via a dropdown combo box in a form it now only seems that a blank form is 'recovered' albeit the code is still correct (unchanged). I have noticed that when I access the table directly there is now a COLUMN with a + sign at the start of each record. When you depress the + sign it 'pops-up' the relationship table, not the whole table but a NEW Record blank line. I can only think that I have changed the format of my Access database. I have made this assumption as when I have accessed previous databases since this is also happening to them., Incidentally, I cleared out ALL data in the hopes that in starting again this would fix the issue. By the way the Excel spreadsheet was virus checked and import was to a new table (since removed and then Appended to the Contact Table.
I know that someone will have the answer as would have come across this before but I can't find the 'fix'.

With much thanks.
 
Assuming you are looking at a table or query, when selected, the + shows any related (child) records - if it is blank then that means there are no related records
 
Hi. Many thanks for the quick reply. Before importing the data the + Sign wasn't there and I could 'pull up' records. Now those records, when chosen from the drop down list, are no longer shown and a blank form with NEW is shown, not the record. Before the import the table did not have this + Sign within the table. I need to remove it. Must be some sort of setting somewhere. Do you know how?
Again, really grateful.
 
it will be in your relationships view - untick 'enforce relationships'

It should not really matter as you should be viewing all data through forms and reports, only viewing tables/queries whilst developing
 
Hi CJ_London, Thanks for the suggestion. Just did that and no luck. The + is still there. Must admit I had enforced integrity previously and had no issues. Any other suggestions would be gratefully received.
 
Database issue.png
To follow up on my last reply and to as to assist I have attached a File which shows the table issue.

Again thanks.
 

Users who are viewing this thread

Back
Top Bottom