Assigning an autonumber to a subform

[Shannon]

Sorry if this has been answered before, I looked through and didn't see anything like my problem.

Here it is: I have a subform within a form. The form is based off of my Clients Table just so they can see who they are billing. The subform has a Client ID, as does my Clients table. Everything is working fine except I want to assign an automatic invoice number to the subform. What it is doing is assigning an invoice # to every entry, instead of assigning one number to mutiple entries. If ANYONE has a clue what I need to do next, please respond!

Thanks,
Shannon

 

[AlanS]

I can't really tell what's happening from your description, so I'll guess at what you're trying to do and give suggestions based on that. It sounds as if each client may have multiple invoices, and each invoice may have multiple entries (line items?). If so, you may need to set up a second level subform (for entries) within the existing subform (for invoices). If the AutoNumber field is in your existing subform, it will assign a new number for each new invoice record. You might want to review your table structures and relationships, and make sure your form hierarchies match them.