Tables

[Majic]

Hello everyone,

I have Four tables that are imported from another source. One is
called "CASS"-reference table, second called "NONBAR" reference table
and the third is called "Items" reference table, fourth is
"Sales" (table where I store information).
I am pulling a query from the four tables that will have the following
info:
Sales Order, Item Number, Description, Quantity, Pulled (Checkbox -
from Sales Table)

Because I created a subform from the query, when I check the checkbox,
all the boxes get checked. I need to be able to create a subform from
all the four tables without a query. Could I do that? How?

Thank you

 

[Jeff Boyce]

Without a look at the SQL statement of your query, it will be tough to
diagnose...

However, it would be unusual for a query spanning four tables to be
updatable (i.e., usable in a form).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hello everyone,

I have Four tables that are imported from another source. One is
called "CASS"-reference table, second called "NONBAR" reference table
and the third is called "Items" reference table, fourth is
"Sales" (table where I store information).
I am pulling a query from the four tables that will have the following
info:
Sales Order, Item Number, Description, Quantity, Pulled (Checkbox -
from Sales Table)

Because I created a subform from the query, when I check the checkbox,
all the boxes get checked. I need to be able to create a subform from
all the four tables without a query. Could I do that? How?

Thank you

It would be simplest to use Combo Boxes on the form, to *display* the
looked-up values from your reference table but *store* the numeric value.
Since you don't say anything about the structure of your actual tables, it's
more than a bit difficult to guess how this should be done! Care to post the
SQL of your query and/or descriptions of your tables?

John W. Vinson [MVP]