Need a Form With sub form with populated client info and a subform with services and price in items invoice, please help (1 Viewer)

Shoebnisar

New member
Local time
Today, 15:39
Joined
Jun 12, 2025
Messages
1
Hello sir,
I have 2 tables 1 Customer, 2 Services with price, now i need a form where i can make invoice populating customers details from customer table and the services (combobox) we give with price. can you please help...
 

Attachments

Your database seems simple enough, but there's a few things I don't understand.

1. Only one item goes to an invoice? That seems different from every other invoicing system in the world. Usually a system like this has 4 tables--Clients, Items, Invoices and InvoiceItems. That way an invoice can have multiple items and they go into InvoiceItems. So, is it accurate that an invoice will only ever have one item with it?

2. You mentioned services in your question--why? Further you said there were 2 services, but from the drop down I see 5. And you attach those to the Client table and have that figured out already--so why is it mentioned in your post? Lastly, what is a service? How does it differ from an item and is it accurate that a client can only have 1 of them?

3. Why do you have a save button on your forms? It's a bound form as soon as I type something in a field the record gets created and saved. I see there is no code behind the button, but why the button at all.

4. Why do you want to allow deletions? You also have delete button on your forms without code, but I assume its coming--but why? Clients are going to get assigned to an invoice and so will items, if you allow users to delete Clients or items it is very likely you will end up with Invoice records that don't have matching item or client records because people came along later and deleted them. Instead of deleting data it is often best to flag it as inactive. So instead of allowing deletions add a Yes/No field where users can mark a client or item as inactive and have it be removed from further use that way.
 
It's a bound form as soon as I type something in a field the record gets created and saved.
Not quite the way it works. But, yes, Access does automagically save the data you entered on a form but it doesn't do it until you leave the current record and that can happen several ways such as closing Access, closing the form, scrolling to a new record, or clicking into a subform from a main form or by clicking in the mainform after modifying data in the subform. You can also force a save by using code.
 

Users who are viewing this thread

Back
Top Bottom