Access Queries

[Guest]

First I am new to some of this stuff. My problem is I have a form which Is
supported with a table (sales). I needed to point to two tables (sales and
number-of buildings). So built a query (salesQuery) where I could have both
tables. It mostly worked, until I tried to add a new record. I got the
message: 'you can't go to the specified record'. What di I need to do to
allow new records. If I use the 'sales' table its ok, but I cannot use two
tables??

 

[Allen Browne]

Create a form bound to one table, with a subform bound to the other table.

You can now create a new record in one table in the main form, and the other
table in the subform.

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s