i have 3 tables, member, loan, category and a linked excel file which holds video details and is named video details.
before i test the relation ship without linking to an excel file and everything was ok, but when i transfered my data to an excel file and imported it the relationship from the category table was not available.
video details (exel linked)
member id linked to member id
video id linked to video id
category id lined to category id
the problem occurs when i open the category table. there is aplus sign next to each category ID but not video details appear. how can i fis this.
when i transfered my data to an excel file and imported it the relationship from the category table was not available.
Why on earth are you exporting data to excel and then re-importing it?
What do you mean the relationship is not "available"? Do you delete the table before re-importing it?
I would suggest that the problem is that while in Excel, which has no clue what a relationship means, the data integrity is being lost... perhaps by a data conversion issue in the process of export/import... perhaps by user modifications... so when you try to import it again it is impossible to re-create the relationship?