Pulling from three tables

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

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?
 
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.
 
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?
 
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?
Click to expand...

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.
 
Back
Top