Primary key and yes/no boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Make-table query that extracts 12 fields from one table and
1 field from another.
The new table is created succesfully with all of the correct information but
the table is missing two things:

1) The primary key symbol is not included in the design view of the new table
2) The Yes/No box that is in the original table (seen when table is opened)
is replaced by 0's and -1's in the new table
 
* Make-Table query doesn't know which Field you want to be the PrimaryKey.
Remember that the Make-Table can use more than one Table as the source
hence, Access/Jet cannot assume (one of) the PKs in the source is the PK for
the destination Table.

Generally, I don't use Make-Table Queries. I prefer to create the
(destination) Table structure (as I need including the PK) and then use an
Append Query to append Records into the Table rather than using Make-Table
Query.

* For Boolean Field values:
True = -1 which can also be formated as Yes
False = 0 which can also be formatted as No
 
Back
Top