Template Terrors

  • Thread starter Thread starter Stephanie Wells
  • Start date Start date
S

Stephanie Wells

I used the Wizard to make an Order Entry Database. I'm pleased with how it
looks, I just needed to add a field to the Order Details and have it show up
on the Invoice. I added the field to my order entry table, but I can't seem
to get it to pull over into the report. Can anybody help me with this? I'm
getting desperate.

Also, is there a way to start the AutoNumbering at a different number than
1?
 
Stephanie said:
I used the Wizard to make an Order Entry Database. I'm pleased with how it
looks, I just needed to add a field to the Order Details and have it show up
on the Invoice. I added the field to my order entry table, but I can't seem
to get it to pull over into the report. Can anybody help me with this? I'm
getting desperate.
Click to expand...

Check the report's Record Source, I'll bet it's a query. If
so, then you need to modify the query to include the new
field.

Also, is there a way to start the AutoNumbering at a different number than
1?
Click to expand...

If you are concerned with the value of an Autonumber field,
then you need to create your own mechanism. AutoNumbers are
only intended to be used as a surrogate key and should not
be exposed to users.

An autonumber primary key field is not guaranteed to be
anything other than unique. It may look sequential now, but
it can go negative or even become randon. If you should
ever start to use replication, then the autonumbers are not
even numeric.
 
Back
Top