harryfraser
Registered User.
- Local time
- Today, 16:08
- Joined
- Dec 14, 2010
- Messages
- 19
Hi there,
I have designed an accounts management system and was hoping to use the import function, however I have some issues which I think are down to the relationships.
I have two tables that I want to import the data to - InstitutionsTbl and ContactsTbl. I have ensured that the fields match up between the spreadsheet and the database.
The relationship is a one to many type relationship - one institution, or organisation can have many contacts associated with it.
I am able to import the institutions details without a problem. However I cannot import the contacts associated with the institution - it just errors.
Would appreciate any help.
Thanks
Harry
I have designed an accounts management system and was hoping to use the import function, however I have some issues which I think are down to the relationships.
I have two tables that I want to import the data to - InstitutionsTbl and ContactsTbl. I have ensured that the fields match up between the spreadsheet and the database.
The relationship is a one to many type relationship - one institution, or organisation can have many contacts associated with it.
I am able to import the institutions details without a problem. However I cannot import the contacts associated with the institution - it just errors.
Would appreciate any help.
Thanks
Harry