Re: database problem
Hello Mary Lou! Hi Folks, I have created 2 tables in design view: Basic Table and Dues Table. Please read the attachment to see the tables. My previous e-mail was not so easy to read. There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data intothe Dues table. Yes it is better to ask such questions in a user forum. In your second table you need also a unique primary key (simply an autoincrement). Without such a column your table will stay readonly. Regards, Mathias - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
database problem
Hi Folks, I have created 2 tables in design view: Basic TableID (key) Integer [INTEGER] Last Name Text [VARCHAR]..other varchar fields** Dues TableID (Index) not unique Integer [INTEGER]Dues Paid Decimal [Decimal]Date Dues Paid Date [Date] **There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data into the Dues table. Can anyone help me? Mary Lou
Re: database problem
Can you please ask this question on the user forum: https://forum.openoffice.org/en/forum/? There are more people available for user support there. You will need to register to post your question. Best regards, Francis On Wed, Mar 25, 2015 at 11:37 AM, Mary Lou Trice maryl...@flash.net wrote: Hi Folks, I have created 2 tables in design view: *Basic Table *and *Dues Table.* Please read the attachment to see the tables. My previous e-mail was not so easy to read. There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data into the Dues table. Can anyone help me? Mary Lou - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
database problem
Hi Folks, I have created 2 tables in design view: Basic Table and Dues Table. Please read the attachment to see the tables. My previous e-mail was not so easy to read. There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data intothe Dues table. Can anyone help me? Mary Lou Basic and Dues tables.docx Description: MS-Word 2007 document - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: database problem
On Wednesday, March 25, 2015 05:37:36 PM Mary Lou Trice wrote: Hi Folks, I have created 2 tables in design view: Basic Table and Dues Table. Please read the attachment to see the tables. My previous e-mail was not so easy to read. There is a relationship between Basic.ID and Dues.ID I can enter data into the Basic table but cannot enter data intothe Dues table. Can anyone help me? Mary Lou Please use ODT, docx and odt have issues when it comes to fields because they manage them different. OpenOffice has it's own widet set by inserting form controllers (Insert - Form controllers). If the other parties use OpenOffice, you are safe, if you dont and you need to share, then you are out of luck and should use something different like Google Forms. (or encourage the other parties to also use OpenOffice :) ) signature.asc Description: This is a digitally signed message part.