If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pulling from three tables
Hi I have a query which runs when the form is openned
unfortunately I can't save using: DoCmd.RunCommand acCmdSaveRecord it doesn't know which table to save the record to I'm assuming can someone give me some direction? |
#2
|
|||
|
|||
Pulling from three tables
When you say "pulling from three tables", do you mean that the RecordSource
of the form is based on a query that joins three tables? As it says in http://office.microsoft.com/en-us/ac...33.aspx#cannot you cannot edit the data in a query when the query is based on three or more tables and there is a many-to-one-to-many relationship. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Emma" wrote in message ... Hi I have a query which runs when the form is openned unfortunately I can't save using: DoCmd.RunCommand acCmdSaveRecord it doesn't know which table to save the record to I'm assuming can someone give me some direction? |
#3
|
|||
|
|||
Pulling from three tables
If the query is updateable, (it may not be) it should save to the table
who's primary key is in the query. The other tables will have the same value in the foreign keys. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Emma" wrote in message ... Hi I have a query which runs when the form is openned unfortunately I can't save using: DoCmd.RunCommand acCmdSaveRecord it doesn't know which table to save the record to I'm assuming can someone give me some direction? |
#4
|
|||
|
|||
Pulling from three tables
I guess I can't use a query to pull from the three tables. I'll have to put
two of the tables together into one table. The problem being that I can now only have one autonumber in the new table so how can I fake the second tables autonumber? "Arvin Meyer [MVP]" wrote: If the query is updateable, (it may not be) it should save to the table who's primary key is in the query. The other tables will have the same value in the foreign keys. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Emma" wrote in message ... Hi I have a query which runs when the form is openned unfortunately I can't save using: DoCmd.RunCommand acCmdSaveRecord it doesn't know which table to save the record to I'm assuming can someone give me some direction? . |
#5
|
|||
|
|||
Pulling from three tables
On Tue, 18 May 2010 08:41:02 -0700, Emma
wrote: I guess I can't use a query to pull from the three tables. I'll have to put two of the tables together into one table. The problem being that I can now only have one autonumber in the new table so how can I fake the second tables autonumber? What is the nature of the data? What are the relevant fields? Why do you need two autonumbers? A bit of context might help folks make some alternative suggestions. I'm a bit uncomfortable with having two "autonumbers" in one table (one of them would seem to be redundant), and equally so with jamming two valid entities into one table. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Pulling from three tables
That doesn't sound right to me. Please post the structure of your tables and
the SQL of the query that you are attempting . -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Emma" wrote in message ... I guess I can't use a query to pull from the three tables. I'll have to put two of the tables together into one table. The problem being that I can now only have one autonumber in the new table so how can I fake the second tables autonumber? "Arvin Meyer [MVP]" wrote: If the query is updateable, (it may not be) it should save to the table who's primary key is in the query. The other tables will have the same value in the foreign keys. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Emma" wrote in message ... Hi I have a query which runs when the form is openned unfortunately I can't save using: DoCmd.RunCommand acCmdSaveRecord it doesn't know which table to save the record to I'm assuming can someone give me some direction? . |
Thread Tools | |
Display Modes | |
|
|