Pulling from three tables
in [General]
|
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 http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Emma" <Emma(a)discussions.microsoft.com> wrote in message news:0DFDA7D7-8D62-4133-B215-6C2D26167444(a)microsoft.com... >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" <Emma(a)discussions.microsoft.com> wrote in message >> news:BF1E05D5-3613-4DDF-8406-FED0EF8ADF63(a)microsoft.com... >> > 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? >> >> >> . >> |