Autonumber on Subform

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

is there a way to create a subform that will use an
autonumber based on a lookup item?
brook
 
Brook, More info please. I will say that you can use an autonumber in any
table you want to. Every time you add a new record the autonumber will
increment. Don't quit understand what you mean by a lookup item.
 
Here is what I have an want to accomplish:

I have 3 tables: tblClientList, tblItemList and
tblInhouseOrders. What I want to do is set up a form that
I can use to order "restock" items for my company. When I
open the form I choose my own company from the client
table, and on a subform based on my tblInhouseorders and
have it set up so that my Item on my tblinhouseorders uses
a look up on my tblItemList and when I choose an item from
the drop down box, it gets a serial number assigned to it.
Hope this is clear. Thanks for your help.

Brook
 
It sounds like you need at least another table to tie
everything together.

tblClientList stores information about each client and is
linked to tblInhouseOrders by some means such as ClientID.

tblItemList merely contains a list of possible purchase
items but it doesn't link to anything. However it could
contain an autonumber field that gives each item a unique
identifier such as ItemID....a form of serial number.

I would think you would need a detail table
(tblOrderDetail) that would store the individual items per
order and link by OrderID. This table would store each of
the ItemID's for each of the orders.
 
Yeah, what Bob said. Sounds right to me. Northwind database that ships
free with access has some good examples of what you might be trying to
accomplish.
 
Back
Top