Posted: Tue Jul 29, 2008 6:56 am Post subject: Form and fields from 4 tables
Like in the sample of birds, I have 4 tables with relationships:
SubFamily, Tribe, Genus and Species
No problem about the relationship when I ask for a query with fields of the 4 tables.
But when I want a form from this query, it's not possible to modify, add or delete data.
I try with a form from the table species only and no problem.
Thanks a lot for your help.....
Just another thing, how it's possible to increase the speed when you use the button "fin records" on a form. I have more than 33 000 records so you can imagine...
Posted: Tue Jul 29, 2008 8:31 am Post subject: Re: Form and fields from 4 tables
Cerambyxdata wrote:
No problem about the relationship when I ask for a query with fields of the 4 tables.
But when I want a form from this query, it's not possible to modify, add or delete data.
With databases, doing a query with multiple tables will, in most cases, will create a temporary table. A temporary table is created when you have any "one to many" relationships between tables in your query.
When a query creates a temporary table, it is not editable as all changes would be made to the temporary table, not the underlying tables that the temporary table was constructed from.
The simplest way to avoid creating a temporary table is to create a separate input form for each table.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Tue Jul 29, 2008 8:36 am Post subject:
Forms based on queries don't allow you to edit the data, I'm afraid. (Actually, most queries aren't editable)
It sounds like you probably need to use a series of subforms. That will let you edit the data. This wiki article discusses how to add a subform to a form without using the wiki. It is the process that must be used to add more than one subform to a form. [Note for others who read this thread: the link is to the French article; the English version can be found by clicking the word "English" in the box near the bottom of the wiki article].
I'm not sure if there is a way to speed up getting to the end of the records. I would suggest you try the subforms and see if that helps. It might help to use Views (essentially a special kind of query). But I don't think you will be able to edit data that way, and I'm not sure if it would help, so I won't go into how to do that now.
I did not have any trouble understanding you, but if you don't know how to say something in English, please feel free to use French. English is my native language, but I'm fairly fluent in French. at least one of our other regulars is French speaking, too. So we can translate your French comments as needed, or explain something in French if you don't understand the English explanation.
Lorinda
P.S. Can you say more about your database? There might be a better way to set up the tables.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Thu Jul 31, 2008 7:45 am Post subject:
Summary: Cerambyxdata has been working on a database containing information about all the species and subspecies of Coleoptera using Access 1997. He wants to be able to freely share this information, but cannot do so through Access, so he is working on rebuilding the database in NeoOffice. He attempted to attach some screen shots, but was unable to do so.
I have sent Cerambyxdata a private message with information on how to send the database to me, so I can take a look.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum