From: Arvin Meyer [MVP] on 18 May 2010 21:30
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
"Emma" <Emma(a)discussions.microsoft.com> 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
> only have one autonumber in the new table so how can I fake the second
> "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
>> in the foreign keys.
>> Arvin Meyer, MCP, MVP
>> "Emma" <Emma(a)discussions.microsoft.com> 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?