On 30/09/14 01:11, Mark Stanton wrote:
Have you checked the contacts table directly? I wouldn't mind betting
that you *have* been able to add contacts, but they don't have the
people primary key. I think you'll need to do some extra work
manually (ie programming, not literally by hand) to get that to work.
This is based on a distant memory though, so I may be wrong.
Regards
Mark
The data in the two tables, people and contacts are the same as in my
Access base. In the Access forms I can add contacts in the contact
subform. In the Base forms when I change the person the contacts subform
changes to match the person. When I checked the table definitions in
Base I found that the primary key could not be made auto if there was
data in the table. I deleted all of the data in the contacts table,
changed the primary key definition and re-imported data. Now my forms
work correctly. One other thing, I found that if the spreadsheet format
for date was not YYYY-MM-DD the import failed.
I now have a fully functional database which does all that I require and
so can now drop virtualbox, windows XP and OfficeXP from this machine.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
